Why not look at v$sql and v$db_object_cache both of which have memory usage statistics Also see the following Oracle support document(s): Diagnosing and resolving ora-04031 error 146599.1 Troubleshooting and Diagnosing ORA-4031 Error 396940.1 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prabhu Krishnaswamy Sent: Wednesday, March 02, 2011 9:31 AM To: oracle-l@xxxxxxxxxxxxx Subject: SQL with High memory Lists, We are facing serious 4031 issue on one of our critical production instances, we thought of reviewing the high memory consuming SQL and the check its usiing bind or not. Any help how to get the TOP 20 SQLs which are consuming high memory. Thank you, Prabhu