-
Periodically experience ORA-04031
DBAs,
We have 3 old databases, which stay at 8.1.7.0. 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.
Thanks,
Lily
-
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.
"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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|