query to find high temp usage
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Fri, 1 Feb 2013 17:45:01 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817DF453E_at_M1EXCHMB11.mmi.local>
I am having a hard time finding queries that consistently use a lot of temp i/o for sorts and joins. In the AWR. Anyone have any quick pointers for 11.2.0.2?
Date: Fri, 1 Feb 2013 17:45:01 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817DF453E_at_M1EXCHMB11.mmi.local>
I am having a hard time finding queries that consistently use a lot of temp i/o for sorts and joins. In the AWR. Anyone have any quick pointers for 11.2.0.2?
Thanks for your time,
Josh C.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 18:45:01 CET