I think only "level 12 traces" produce wait events output.
I want to see the "wait events" along with my cost for a particular query.
My environment:
Sun Solaris (SUNOS 5.9) Oracle 9.2.0.7
TIMED_STATISTICS is not set in the parameter file....
So, I am doing
SQL> alter session set sql_trace=true; SQL> alter session set timed_statistics=true; SQL> "running the SQL here"
After getting the trace:
$ tkprof <trace file> <output file> explain=... sys=no waits=yes
But the "output file" never produces the "wait events"
Any ideas?
TIA
Nirmalya -- //www.freelists.org/webpage/oracle-l
-- " ,--o -\\_<_ (*)/-'(*)