RE: tkprof question

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nirmalya Das Sent: Friday, May 19, 2006 12:13 PM
To: oracle-l_at_freelists.org
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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 19 2006 - 12:34:19 CDT