Re: trace to find time spent in memory sorts

From: Kurt <kurtengelo_at_gmail.com>
Date: Thu, 23 Feb 2012 08:41:06 -0800
Message-ID: <CAOKMGhaen1-7GT4R-OjpaB4Ry3A_u1=Kkq_VLu9XsiVufD1g=g_at_mail.gmail.com>

Hi,
And of course there's real time SQL monitoring, which will give you a nice graphical view of the plan and timings:

http://www.oracle.com/technetwork/database/focus-areas/manageability/sqlmonitor-084401.html

Real time SQL monitoring requires the Diagnostic and Tuning pack licenses.

Kurt

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.
>
> 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.
>
>
>

-- 
The opinions expressed in this email are my own, and not my company's.


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

Received on Thu Feb 23 2012 - 10:41:06 CST