Re: tkprof question

  • From: "Larry Lutz" <larry.j.lutz@xxxxxxxxx>
  • To: nirmalya@xxxxxxx
  • Date: Fri, 19 May 2006 14:30:49 -0400

I think only "level 12 traces" produce wait events output.

On 5/19/06, Nirmalya Das <nirmalya@xxxxxxx> wrote:

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
-\\_<_
(*)/-'(*)

Other related posts: