It's been a while since I looked at the sort traces, but I *think* event 10032 will give that information, albeit possibly tangentially. On Feb 23, 2012 2:13 AM, "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