tkprof question
- From: Nirmalya Das <nirmalya@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 19 May 2006 10:13:22 -0700
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
Other related posts:
