trace to find time spent in memory sorts
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Thu, 23 Feb 2012 02:11:28 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817CA880F_at_M1EXCHMB13.mmi.local>
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,
Date: Thu, 23 Feb 2012 02:11:28 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817CA880F_at_M1EXCHMB13.mmi.local>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 22 2012 - 20:11:28 CST