Periodically experience ORA-04031
We have 3 old databases, which stay at 126.96.36.199. Due to some reason, we cannot upgrade them
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.
Our current practice is just restarting the database.
But is there other good way to help solve this problem instead of database restart.
Increase the SHARED_ POOL_SIZE and SHARED_ POOL_RESERVED_SIZE. Stop bouncing the database.
Originally Posted by Lily_Liu_2004
If you dont have much physical memory reduce your use of shared memory.
"What is past is PROLOGUE"
increasing wont help, will just put it off and maybe give you more errors / performance problems
fix the application and make it use bind variables
Click Here to Expand Forum to Full Width