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: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 19 May 2006 14:52:54 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2708059E84@AABO-EXCHANGE02.bos.il.pqe>


Actually, 4=basic trace+binds and 8=basic trace+waits. 12=4+8=basic trace+binds+waits.  

-Mark
 

PS For completeness, level=1 is basic trace only, no waits or binds.  

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988  


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 - 13:52:54 CDT

Original text of this message

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