SQL with High memory

From: Prabhu Krishnaswamy <prabhu_adam_at_hotmail.com>
Date: Wed, 2 Mar 2011 14:30:49 +0000
Message-ID: <BAY142-W7D452B2D9FF366793555585C00_at_phx.gbl>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 02 2011 - 08:30:49 CST

This message: [ Message body ]
Next message: Guillermo Alan Bort: "OEM 11g Not alerting of critical status..."
Previous message: Amaral, Rui: "RE: Oracle License Audit"
In reply to: Amaral, Rui: "RE: Oracle License Audit"
Next in thread: Powell, Mark: "RE: SQL with High memory"
Reply: Powell, Mark: "RE: SQL with High memory"
Maybe reply: Denis: "RE: SQL with High memory"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message