To find out resource intensive SQLs

From: Prabhu Krishnaswamy <prabhu_adam@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 28 Jun 2011 09:17:57 +0000

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

Follow-Ups:
- RE: To find out resource intensive SQLs
  - From: Powell, Mark

Other related posts:

» To find out resource intensive SQLs - Prabhu Krishnaswamy
» RE: To find out resource intensive SQLs- Powell, Mark