Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Thu Oct 02 2003 - 12:44:33 CDT
![]() |
![]() |