Re: 'alter session set sql_trace=true' bug or feature ?

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:bs9ht8$1pf$1_at_news.BelWue.DE...
> Holger Baer wrote:

<snip>
> I should have mentioned that the waits are only reported in the raw trace
> file, wherease tkprof seems unable to assign them to the correct
statement.
>
> Holger
>

Hi Holger

I got the results you describe when issuing the sql from sqlplus. if you convert it into the pl/sql version the waits disappear but you see extra cpu time and elapsed time on several (between 1/2 and 1/3 of all FETCH lines) FETCH line in the trace file.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK