shared pool notifications

  • From: P D <pdba1966@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 5 Jul 2011 11:53:59 -0400

Is there a way to get notified that the shared pool is running out of memory 
before it actually occurs?
 
We had a sudden unexpected spike of activity and the database was unable to 
allocate shared memory.     This is a 10.2.0.4 database.    We saw it in the 
alert log but only after it had run out.   Just wondering what other people are 
doing as far as receiving notifications before it runs completely out.          
                                 

Other related posts: