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

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

RE: tkprof question

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Fri, 19 May 2006 15:51:52 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF54E266@WIN02.hotsos.com>


Opps, that should be 12 - 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 Ric Van Dyke
Sent: Friday, May 19, 2006 3:54 PM
To: larry.j.lutz_at_gmail.com; nirmalya_at_hln.com Cc: oracle-l_at_freelists.org
Subject: 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 - 15:51:52 CDT

Original text of this message

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