Re: trace to find time spent in memory sorts

From: Lei Zeng <>
Date: Wed, 22 Feb 2012 23:15:51 -0800 (PST)
Message-ID: <>

Would you turn on 10046 trace for the sql?

For example,
SORT ORDER BY (cr=3 pr=0 pw=0 time5 us)

The 'time' is a total of 'SORT' operation and its sub-steps. Please remember to subtract 'time' of its sub-steps from it.


From: Josh Collier <> To: "" <> Sent: Wednesday, February 22, 2012 6:11 PM Subject: trace to find time spent in memory sorts

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.

Received on Thu Feb 23 2012 - 01:15:51 CST

Original text of this message