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.