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