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.