Re: [Q] wait time /lob def

ling list and > web > > > hosting services > > > > > > - > > > To REMOVE yourself from this mailing list, send > an > > > E-

Re: [Q] wait time /lob def

__ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://

Re: Sun Cluster 3.0 commands

Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http:

Re: Sun Cluster 3.0 commands

Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://ww

Re: Automatic or Uniform allocation

CLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free

Re: any over head with DBMS_STATS.ALTER_DATABASE_TABLE_MONITORING

L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/

Re: Database Instance

ing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please

OT: Display unix directory hierarchy

e the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting ser

RE: rebuilding indexes - sure to cause a ruckus

ling list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for ot

Re: ORA-1000 and pl/sql cursor cache

web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing

Re: xref table - design consideration

bles, you should > use as primary key of > those tables distinct subsets of the primary key of > the 'customers' (as > defined above) table. > > HTH, > > SF > > Barbara Baker wrote: > > > > List: > > We're trying to design a CRM app.

RE: xref table - design consideration

r, or Private Party, or Agency? > In this case, if end-user knows type he is searching > for, the query will > go to specific partition, if not - it'll deal with > the whole table. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > > > > -Original Message-

xref table - design consideration

now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

dbca init.ora incomplete last line

l AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Configuring multi-threaded server

> from). You may > also send the HELP command for other information > (like subscribing). ______ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: htt

Re: End of communication channel

ve jet engines by now. > > On 11/13/2003 09:54:25 AM, Barbara Baker wrote: > > Hi, Stefan. > > We had a problem very similar to this one. Fought > it > > for several months. > > > > The final solution: a bad blade in a router. > > > > Good l

More help with TKPROF

ient13 1.39 4.73 SQL*Net more data to client 1 0.00 0.00 __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORA

Re: End of communication channel

e message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do you Yahoo!? Protect your identity with

Re: Help Interpreting TKProf

eed to know. Is the 10 centiseconds of > time in 8 1.25 > centisecond events or in 1 10 centisecond event and > 7 .1 centisecond > events? The location (parse/execute/fetch/post tx) > are also important. > > Daniel > > Barbara Baker wrote: > > > Hi. > > I&#x

Help Interpreting TKProf

p. Barb __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Oracle Error

- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, i

Metalink: Pwd Problems?

Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list an

Re: using temp tables for staging databases?

for staging > > > databases? > > > >> > > > >> All the time. Oracle Apps's "open > interfaces" > > > are built this way, for > > > >> example. > > > >> > > > >> However, "the guys here" covered their bases >

RE: using temp tables for staging databases?

de a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system > (http:

Re: software which monitoring diferences between instances ?

__ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services

Re: Redos gone crazy--a job for audit?

nges). Then trace back > to the session info, sql, etc. > Also check for tablespaces in hot backup mode. > > Daniel > > Barbara Baker wrote: > > > Hi, list. Ya, I'm still alive and kickin'. > > > > We have this small database that's running a weird

RE: Redos gone crazy--trying to use logminer

ge in error, or > are not the named recipient(s), please immediately > notify corporate MIS at (860) 766-2000 and delete > this e-mail message from your computer, Thank > you.

RE: Redos gone crazy--a job for audit?

; Barb > > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product > search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Barbara Baker > INET: [EMAIL

Redos gone crazy--a job for audit?

New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Californ

upgrade 805 to 8174, type#10 objects

__ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatc

RE: Is Metalink Working

web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: faq broke?

ed fine for me just now. > > What are you searching on? > > Craig Healey > > > -Original Message- > > From: Barbara Baker > [mailto:[EMAIL PROTECTED] > > Sent: 17 July 2003 15:20 > > To: Multiple recipients of list ORACLE-L > > Subject: f

faq broke?

ust me, or are others having problems? Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Networ

Performance problems VMS 8i

Barb __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

Fwd: Re: Sparky auth file

> > Oooops! I haven't read the whole post before > answering. > Sorry, I blew it. > On 2003.07.11 19:34, Barbara Baker wrote: > > Ok, this is a REAL reach. > > But does anyone out there know how to specify the > dump > > directory in the auth f

Sparky auth file

___ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Thanks!! What are the type#'s in obj$ ?

-- -- -- > > 288484 V$TEMPFILE 10 > > > > (Solaris 2.6; Oracle 8.1.7.4) > > Thanks! > > > > Barb > > BAARF party number 20 > > > >

What are the type#'s in obj$ ?

2.6; Oracle 8.1.7.4) Thanks! Barb BAARF party number 20 __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City

RE: Query Tuning Question - new discovery

urself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > al

RE: Deleting Statspack tables.

--- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the na

Re: World premier performance of the BAARF party logo

Q: > __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Deleting Statspack tables.

> from). You may > also send the HELP command for other information > (like subscribing). ______ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACL

RE: Oracle urban legends and myths needed

--- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be remov

RE: Sun HA Monitoring and Oracle 9

;Life is like a sewer, what you get out of it > depends on what you put > into it." - Tom Lehrer. > __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Please see the offic

Re: Script to check for errors

). You may > also send the HELP command for other information > (like subscribing). > ______ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the offi

Re: ORacle Applications mailing list

RACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMO

ORA-01578 data block corrupted on standby

short maintenance window. Any ideas? TIA! Barb __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAI

Grouping records for reporting

tors, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hostin

Re: DBArtisan

ing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.ne

RE: Purely for your amusement

gt; to respond with "Data! You don't need no stinkin' > data!" > __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: Purely for your amusement

ESIAN's in the > plan. Have fun. Oh, and > is the CNR table analyzed? > > Regards, > Mark. > > > > > > > Barbara Baker

Purely for your amusement

Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 ht

Re: initial/next computation with DOP 4

t; -- --- > > WODH_PK 1333.55859 4 20,971,520 > 0 > > WODH_FK1 821.289063 4 20,971,520 > 0 > > > > here's the code . . . > > > > create unique INDEX > > REPORT_REP.WODH_PK > > ON > > > REPORT_RE

initial/next computation with DOP 4

o.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: [Q] create seperate DBA account on 8.1.7 but does NOT work?

you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. htt

iAS 903 902 install

___ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: HELP..URGENT....NOT

__ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: Oracle 9i release 3 coming?

- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Was 8.1.6 certified on Solaris 8?

ved > from). You may > also send the HELP command for other information > (like subscribing). > __________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ:

Re: dbms_job interval 10till

Stephane: Precisely what I was after! Thanks so much for your help. I really appreciate it. Barb --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Barbara Baker wrote: > > > > Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1 > > > > List: > > I wan

dbms_job interval 10till

oken: Any idea how I can get to run consistently at 10 till each hour? Thanks in advance for any help. Barb __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE

Re: Cant install statspack !

Bob: I have a slightly different version.  My spcreate.sql involkes 3 scripts:  @@spcusr,@@spctab,@@spcpkg.  The problem that I had was that spcusr was creating some x_ views that already existed in the database (perhaps from Steve Adams' script).  When the spcusr script encounters the errors, it q

Best upgrade path Linux / 8.1.7

List: We have a Red Hat Linux release 7.1 system with 8.1.7.0 installed.  We're encountering the memory leak bug    ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","begin dbms_output.disable; e...","PL/SQL MPCODE","BAMIMA: Bam Buffer") I need to upgrade to at least 8.1.7

RE: Oracle Application Server on .net

I'll have to check when I'm back at work tomorrow.  There were 2 "2000" errors, so the install thought it was installing on a w2k machine.  One of the errors was something about not able to install on a 2000 terminal server. I'll grab the exact errors tomorrow. Thanks for the links! Barb  "Reardon,

Oracle Application Server on .net

List: I have a developer trying to install Oracle9i Application Server Release 2 (9.0.3) on a .net server.  He's using the install disk for Windows NT and 2000.  Needless to say, it gives him an error and throws up. He considers .net just another operating system like np or 2000.  I think of it mor

Re: Syntax ? For MTS_DISPATCHERS

Here's the line out of my init: mts_dispatchers="tcp,20" (I'm on 8.0.5, Solaris) Barb    Bob Metelsky <[EMAIL PROTECTED]> wrote: AllI cant seem to get the syntax correct on the MTS_DISPATCHERS= inthe initSID.oraIt seems no matter what I use I get a ORA-00101: invalid specification for system parame

Re: STATSPACK

Seema: Head to Tim Gorman's site (www.evdbt.com) and find his sppurpkg.sql download.  It uses dbms_jobs to run with a purge each set number of days. It's really slick. Barb  Seema Singh <[EMAIL PROTECTED]> wrote: HiHow to clean all old STATSPACK data?Thx-Seema___

RE: ORA-1653: unable to extend table - Why?

How badly do you want the space back?  I believe you will indeed need to touch each row. You could update each row with something like (update set column-1=column-1) Good luck! Barb  "Miller, Jay" <[EMAIL PROTECTED]> wrote: But will this solve my problem in the near term? My understanding is t

Re: Export from Oracle 8 to Oracle 7

David: You always want to use the older export utility when exporting from an older DB version, and use the new import untility to import into the newer database. To export from an 8.1.7 database, use the export utility from the version 7 database and export using a link to the new database (exp sy

RE: OT ksh day of week yesterday

Ross: Actually, this solves the problem nicely.  I can always find an oracle database up around here somewhere :) A couple of folks suggested this approach and I was going to work on it yesterday when chaos broke out.  But you were kind enough to give me the code! It's very much appreciated. Thanks

SUMM: OT ksh day of week yesterday

S until version 3... Barb  Alex <[EMAIL PROTECTED]> wrote: > yesterday=$(TZ=EST26EDT date +%a)>> On Wed, 13 Nov 2002, Barbara Baker wrote:>> >> > Will someone take pity on this poor VMS'er lost in a unix world??> >> > I'm trying to create a script (ks

Re: How to tune this query ...

Raj: I had trouble with this very query.  Posted it to this list.  Never came up with anything.  What fixed the query for me was to add the ordered hint (select /*+ ordered */). You might give it a try. Good luck!!   Barb    "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: I am looking at oracle

Re: Diagnose Slow System

Thanks, Tim. I do have a YAPP report from last week when the problems began --  I'll get that to you.  I'll also grab some more data tomorrow.  (If it's consistent, it'll start slowing down about 9:00 tomorrow morning.) Barb   Tim Gorman <[EMAIL PROTECTED]> wrote: Barb,Can you take a BSTAT/ESTAT

RE: buffer busy wait & latch free ( cache buffer chain )

Barb _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Upgrade 8.0.5 to 8.1.6

ot;downloads". Barb _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Upgrade 8.0.5 to 8.1.6

-- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a l