Re: trace to find time spent in memory sorts
Date: Thu, 23 Feb 2012 08:41:06 -0800
And of course there's real time SQL monitoring, which will give you a nice graphical view of the plan and timings:
Real time SQL monitoring requires the Diagnostic and Tuning pack licenses.
On Thu, Feb 23, 2012 at 6:52 AM, TJ Kiernan <tkiernan_at_pti-nps.com> wrote:
> 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.
-- The opinions expressed in this email are my own, and not my company's. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 23 2012 - 10:41:06 CST