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?

Thanks for your time,

Josh C.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 01 2013 - 18:45:01 CET