-
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
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
|