shared pool notifications
From: P D <pdba1966_at_hotmail.com>
Date: Tue, 5 Jul 2011 11:53:59 -0400
Message-ID: <SNT115-W532E7054511FA4536C9882D05F0_at_phx.gbl>
Date: Tue, 5 Jul 2011 11:53:59 -0400
Message-ID: <SNT115-W532E7054511FA4536C9882D05F0_at_phx.gbl>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 05 2011 - 10:53:59 CDT