RE: To find out resource intensive SQLs
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2011 13:11:33 +0000
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
Other related posts: