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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prabhu Krishnaswamy Sent: Tuesday, June 28, 2011 5:18 AM To: oracle-l@xxxxxxxxxxxxx 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