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.
Thanks,
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: 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
11.2.0.2
Thanks for your time,
Josh C.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
