RE: TKPROF

I thought I knew tkprof well, but I never knew that the sort effectively means 
sort by the sum of these 3 not by each in turn.  Thanks, Niall.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Niall Litchfield
Sent: Wednesday, September 06, 2006 11:55 AM
To: danielwfink@xxxxxxxxx
Cc: crcbedoy@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: TKPROF


Almost exactly my preferences. I tend to add in a record=sqlfilename as well. I 
find this can help me understand the transactions a wee bit better often. 

To the OP what Daniel's command will give you is user issued SQL ( i.e no 
recursive sql) in descending elapsed time order (the sort effectively means 
sort by the sum of these 3 not by each in turn) and with wait information 
detailed (assuming you captured it in the trace).  

cheers 

Niall



==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: