RE: trace to find time spent in memory sorts

From: TJ Kiernan <>
Date: Thu, 23 Feb 2012 08:52:26 -0600
Message-ID: <>

Is there any reason you can't add /*+ GATHER_PLAN_STATISTICS */ to your query and then select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'));

You should be able to see the actual time spent on each step of the execution without digging through a trace file.

T. J.
The information contained in this message is privileged and confidential information intended only for the use of the individual or entity identified above. If the receiver of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify the sender by replying to his/her e-mail address noted above and delete the original message, including any attachments. Thank you.

-----Original Message-----

From: [] On Behalf Of Josh Collier Sent: Wednesday, February 22, 2012 8:11 PM To:
Subject: trace to find time spent in memory sorts

How can I find out how much time is spent by a query in memory sorts? i can easily get i/o timings, but I have suspicion my query is spending all its time on sorts... 64 bit linux
Thanks for your time,

Josh C.


-- Received on Thu Feb 23 2012 - 08:52:26 CST

Original text of this message