RE: trace to find time spent in memory sorts

  • From: "TJ Kiernan" <tkiernan@xxxxxxxxxxx>
  • To: <Josh.Collier@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 23 Feb 2012 08:52:26 -0600

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 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Josh Collier
Sent: Wednesday, February 22, 2012 8:11 PM
To: oracle-l@xxxxxxxxxxxxx
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.



Other related posts: