Re: trace to find time spent in memory sorts

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: Josh.Collier@xxxxxxxxxxxx
  • Date: Thu, 23 Feb 2012 09:08:28 +0100

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


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


Other related posts: