Notes in-line
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
April 2004 Iceland http://www.index.is/oracleday.php
June 2004 UK - Optimising Oracle Seminar
"srivenu" <srivenu_at_hotmail.com> wrote in message
news:1a68177.0403310442.c932756_at_posting.google.com...
> Jonathan,
> Are you sure that the tracing session uses the AUDSID to find out the
> first session ?
> If i issue SET AUTOTRACE TRACE STATISTICS
>
> Because on my local 9.2.0.3.0 i traced the sessions and saw that the
> SID is passed to the tracing session using this SQL
> SELECT DISTINCT SID FROM V$MYSTAT
Confirmed on 9.2.0.4 and 10.1.0.2 - I guess the change
was just after 9.2.0.1
> Whereas if i issue SET AUTOTRACE TRACE EXPLAIN
> it is issuing this SQL
> SELECT USERENV('SESSIONID') FROM DUAL
>
Still the same in 9.2.0.4 and 10.1.0.2 - but the explain plan
for SYS uses 'PLAN0' as the statement_id in 9.2, but
'PLAN4294967295' (0xFFFFFFFF) in 10.1.
Received on Thu Apr 01 2004 - 02:13:04 CST
