RE: TKPROF

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 6 Sep 2006 18:18:37 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E801@ENYC11P32005.corpny.csfb.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Niall Litchfield Sent: Wednesday, September 06, 2006 11:55 AM To: danielwfink_at_yahoo.com
Cc: crcbedoy_at_proteccion.com.co; oracle-l_at_freelists.org 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

---

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

Received on Wed Sep 06 2006 - 12:18:37 CDT