RE: STAT from trace

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On 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: ml-errors_at_fatcity.com
>>[<mailto:ml-errors_at_fatcity.com>mailto:ml-errors_at_fatcity.com]On 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:hporas_at_etal.uri.edu>mailto:hporas_at_etal.uri.edu]
>>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: breitliw_at_centrexcc.com

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: ListGuru_at_fatcity.com (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).