RE: To find out resource intensive SQLs

From: Powell, Mark <>
Date: Tue, 28 Jun 2011 13:11:33 +0000
Message-ID: <>

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: [] On Behalf Of Prabhu Krishnaswamy Sent: Tuesday, June 28, 2011 5:18 AM
Subject: To find out resource intensive SQLs


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 - 08:11:33 CDT

Original text of this message