RE: TKPROF
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 6 Sep 2006 18:18:37 +0100
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:
