Oracle 220.127.116.11 had a known bug with ORA-4031 errors. Typically, the ORA-4031 error means that you do not have enough free space in your Shared Pool. So one would increase the SHARED_POOL_SIZE parameter and bounce the database. This is the first thing you should try. If that does not fix your problem, then you are running into the known bug with Oracle 18.104.22.168 where the instance did a poor job of memory management in the Shared Pool. The fix is to apply the 22.214.171.124 patchset or upgrade to Oracle 9.2.0.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.