Btw, reading through a 10046/12 trace from instance startup & database opening can reveal really lots of interesting information.... :)
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 06, 2004 8:24 PM > Thanks, Raj, but I don't think so. The whole reason > behind enabling a db-wide trace was to capture > everything sql trace is instrumented to capture. As > you know sql_trace is a static parameter, so I got > everything "from the begining", including: > > PARSING IN CURSOR #1 > ALTER DATABASE MOUNT > .. > PARSING IN CURSOR #1 > ALTER DATABASE OPEN > > PARSING IN CURSOR #2 > create table bootstrap$ ( line# > > PARSING IN CURSOR #2 > CREATE ROLLBACK SEGMENT SYSTEM > > .. but not the cursor #0 > > (Interestingly "alter database mount" went to one > trace file, while "alter database open" and the rest > to another - so to mount a DB Oracle spawns a > different process on your behalf and than passes > control back to your foreground to open it?) > > > --- "Jamadagni, Rajendra" > <[EMAIL PROTECTED]> wrote: > you may not be > seeing parse etc entries for cursor > > #0 merely because maybe by design, cursor#0 gets > > invoked before trace gets activated. This way, you > > will never get cursor #0 info. > > > > You can tell, I am guessing but to get similar > > experience, start trace in an already active session > > and you'll see. > > Raj > > > -------------------------------------------------------------------------- ------ > > Rajendra dot Jamadagni at nospamespn dot com > > All Views expressed in this email are strictly > > personal. > > QOTD: Any clod can have facts, having an opinion is > > an art ! > > > > > > -----Original Message----- > > Sent: Tuesday, January 06, 2004 12:00 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Thanks to Anjo, Cary, Tanel, and everybody who > > provided feedback back channel. > > > > Just to rule out the possibility of a collection > > error > > (somebody suggested that cursor #0 is simply not > > captured) I bounced the DB today, enabled a DB-wide > > trace ... and as expected > > > > grep -i "cursor #0" * > > > > returned nothing, while "wait #0" gives plenty. So > > it > > is not a trace activation/termination error. > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > -- > > Author: Jamadagni, Rajendra > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > > http://www.fatcity.com > > San Diego, California -- Mailing list and 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: 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). > > ______________________________________________________________________ > Post your free ad now! http://personals.yahoo.ca > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Boris Dali > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and 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: 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and 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: 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).