To find out resource intensive SQLs
From: Prabhu Krishnaswamy <prabhu_adam_at_hotmail.com>
Date: Tue, 28 Jun 2011 09:17:57 +0000
Message-ID: <BAY160-w458181925D0DD8E8C2C31E85560_at_phx.gbl>
Date: Tue, 28 Jun 2011 09:17:57 +0000
Message-ID: <BAY160-w458181925D0DD8E8C2C31E85560_at_phx.gbl>
Lists,
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
Prabhu
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 28 2011 - 04:17:57 CDT