SQL with High memory

  • From: Prabhu Krishnaswamy <prabhu_adam@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 2 Mar 2011 14:30:49 +0000

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                                    

Other related posts: