Re: Conceivably a daft question...

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
Then using this SID, the tracing session is using this SQL to get the statistics about the traced session.
SELECT STATISTIC# S, NAME
FROM SYS.V_$STATNAME
WHERE NAME IN ('recursive calls','db block gets','consistent gets','physical reads','redo size','bytes sent via SQL*Net to client','bytes received via SQL*Net from client','SQL*Net roundtrips to/from client','sorts (memory)','sorts (disk)') ORDER BY S

Whereas if i issue SET AUTOTRACE TRACE EXPLAIN it is issuing this SQL
SELECT USERENV('SESSIONID') FROM DUAL Can you please check it out.
regards
Srivenu Received on Wed Mar 31 2004 - 06:42:13 CST