Tanel, that's not correct. 10046 <> 10053. To get the STATs lines the
trace buffer has to be flushed i.e. the cursor has to be closed and
the next statement is processed (or user closes the session) -- depends
on the nature of the application, types of opened cursors and
instance/session settings.
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Tanel Poder wrote:
> Hi!
>
> This is the problem, that everything else was identical. If you executed
> exactly the same query again, it didn't get hard parsed anymore, thus no
> STAT lines were generated. Either flush shared pool or just add some bogus
> comment using /* */ into your query to get parsing and STAT lines.
>
> Tanel.
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 01, 2003 4:34 PM
>
>>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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
INET: Vladimir.Begun_at_oracle.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).
Received on Wed Oct 01 2003 - 14:44:45 CDT
