RE: tkprof question
- From: "Schultz, Charles" <sac@xxxxxxxxxxxxx>
- To: <nirmalya@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 May 2006 12:34:19 -0500
Alter session set events '10046 trace name context forever, level 12';
That will also give you bind variable information, which you did not ask
for, but never hurts. =)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nirmalya Das
Sent: Friday, May 19, 2006 12:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: tkprof question
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; "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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
