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).
