Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> tkprof question

tkprof question

From: Nirmalya Das <nirmalya_at_hln.com>
Date: Fri, 19 May 2006 10:13:22 -0700
Message-ID: <20060519101322.srzqc8os8swkcsow@www.hln.com>


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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US