RE: tkprof question

10046 Trace levels

4 - BINDs

8 - waits

2 - combines levels 4 and 8 (binds and waits)      

Ric Van Dyke

Hotsos Enterprises

Cell 248-705-0624

Hotsos Symposium March 4-8, 2007. Be there.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Larry Lutz Sent: Friday, May 19, 2006 2:31 PM
To: nirmalya_at_hln.com
Cc: oracle-l_at_freelists.org
Subject: Re: tkprof question  

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

On 5/19/06, Nirmalya Das <nirmalya_at_hln.com > 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
--

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

--

" ,--o
-\\_<_
(*)/-'(*)

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 19 2006 - 14:54:04 CDT