To find out resource intensive SQLs

From: Prabhu Krishnaswamy <>
Date: Tue, 28 Jun 2011 09:17:57 +0000
Message-ID: <BAY160-w458181925D0DD8E8C2C31E85560_at_phx.gbl>


Is there simple way (through SQL) to find out the active SQLs that is consuming high resources like CPU, SHARED MEMORY, and TEMP SPACE.  

Thank you

Received on Tue Jun 28 2011 - 04:17:57 CDT

Original text of this message