Re: trace to find time spent in memory sorts
- From: Kurt <kurtengelo@xxxxxxxxx>
- To: tkiernan@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Feb 2012 08:41:06 -0800
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@xxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
