Re: trace to find time spent in memory sorts
Date: Thu, 23 Feb 2012 09:08:28 +0100
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
If you manage to map the c-function name to your 'in memory sorts' you can estimate how much time you spend there.
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
> Thanks for your time,
> Josh C.