RE: To find out resource intensive SQLs

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Tue, 28 Jun 2011 13:11:33 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B1724159374D6E6BBB2_at_GVW1337EXC.americas.hpqcorp.net>



In sqlplus do a describe on v$sql. There are numerous statistics related to usage, memory, and cpu realted to the SQL statement available via this view.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prabhu Krishnaswamy Sent: Tuesday, June 28, 2011 5:18 AM
To: oracle-l_at_freelists.org
Subject: To find out resource intensive SQLs

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-l
Received on Tue Jun 28 2011 - 08:11:33 CDT

Original text of this message