If you exited the Oracle session without deactivating the trace, then you should probably see a XCTEND as well, right? If you see the XCTEND but no STAT lines, then I think you've found a bug.
Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- Henry Poras Sent: Wednesday, October 01, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Wolfgang, I'll give level 9 a try. Yes I get PARSE, EXEC, FETCH, WAIT. My platform is AIX 5.1 For now I've run sql_trace = true and 10046 level 8 and looked at two seperate trace files. I've had this working before, but I can't remember if it was on 5.1 or when we still were at AIX 4. Thanks for the suggestions. Henry -----Original Message----- Wolfgang Breitling Sent: Wednesday, October 01, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Do you get the PARSE, EXEC and FETCH entries for the sql? You gave us your Oracle version, but what is your platform? Would you care to try the following: since sql_trace = true corresponds to "event 10046, level 1", why not set event 10046 at level 9. Maybe that'll do the trick. At 12:59 PM 10/1/2003, you wrote: >Tried that. Also queried on open_cursors in a parallel session. > >Henry > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of >Daniel Fink >Sent: Wednesday, October 01, 2003 1:59 PM >To: Multiple recipients of list ORACLE-L >Subject: Re: STAT from trace > >Henry, > >What happens if you issue another query after the query of interest? >(something like "select 1 from dual;") STAT should be emitted when the >cursor is closed. > >Daniel > > >Henry Poras wrote: >> Thanks. I tried both disabling the trace and quitting from the session. >> No luck with 10046, just sql_trace.Henry >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED] Behalf Of >>Jamadagni, Rajendra >>Sent: Wednesday, October 01, 2003 10:25 AM >>To: Multiple recipients of list ORACLE-L >>Subject: RE: STAT from trace >> >>I get STAT lines no matter how I enable the trace. Make sure you wither >>close the session or stop the trace so that all pending STAT lines will >>be written to the file. >> >>Raj >> >>-----Original Message----- >>From: Henry Poras [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED] >>Sent: Wednesday, October 01, 2003 9:34 AM >>To: Multiple recipients of list ORACLE-L >>Subject: STAT from trace >> >>I was creating some trace files yesterday and came across one of these >>problems that shows up occasionally (then I forget about it). >> >>When I ran my query using ALTER SESSION SET sql_trace=true (sqlplus; >>8.1.7.4), I got the STAT line in the trace and the associated 'row source' >>information after running tkprof. >> >>When I ran my query using ALTER SESSION SET EVENTS '10046 trace name context >>forever, level 8' (or with dbms_system.set_ev), there were no STAT entries >>for my query. There were some for some of the recursive queries. >> >>Everything else was identical. >> >>What's up? >> >>Henry > >Wolfgang Breitling >Oracle7, 8, 8i, 9i OCP DBA >Centrex Consulting Corporation >http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Henry Poras 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: Cary Millsap 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).
