Re: trace to find time spent in memory sorts

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 23 Feb 2012 09:08:28 +0100
Message-ID: <CALH8A90sj+v21aEDTQjWb8hPLqfQvbkhAgJb6s6HvsD1sPBh=A_at_mail.gmail.com>

Josh,
it's not that comfortable, but you can try to do something like http://blog.tanelpoder.com/2008/10/31/advanced-oracle-troubleshooting-guide-part-9-process-stack-profiling-from-sqlplus-using-ostackprof/

to get the call stack traces where your processes are spending most of the time.
If you manage to map the c-function name to your 'in memory sorts' you can estimate how much time you spend there.

hth
 Martin

On Thu, Feb 23, 2012 at 03:11, Josh Collier <Josh.Collier_at_banfield.net>wrote:

> 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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

Received on Thu Feb 23 2012 - 02:08:28 CST