RE: STAT from trace

No little minds at this place, maybe just hobgoblins. Certainly no consistency. I tried again this morning and everything worked. (of course I don't know what has changed behind the scenes:Oracle patches, OS patches???). Jane, stop this crazy thing.

Thanks for the suggestions. Next time I'll spool my commands immediately so they'll be some record.

Henry

-----Original Message-----
Cary Millsap
Sent: Wednesday, October 01, 2003 6:14 PM To: Multiple recipients of list ORACLE-L

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry Poras
  INET: hporas_at_etal.uri.edu

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


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: hporas_at_etal.uri.edu

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