Quote Originally Posted by Lily_Liu_2004
DBAs,

There is a pattern which after running for 2 or 3 months, we experience a lot of ORA-04031: unable to allocate 4096 bytes of shared memory.

Even flushing the shard pool is no use.
Increase the SHARED_ POOL_SIZE and SHARED_ POOL_RESERVED_SIZE. Stop bouncing the database.

If you dont have much physical memory reduce your use of shared memory.