If you are receiving the ORA-4031 errors, the most common cause is that your SHARED_POOL_SIZE parameter is too small. Consider increasing this parameter.
There was a bug in Oracle 9i where applications would receive this error even if the shared pool was sufficiently large enough. This bug caused the shared pool to mismanage its free memory. This bug was fixed in either 22.214.171.124 or 126.96.36.199 as well as Oracle 10g. You may have to apply a patchset to fix this problem. Consult Metalink for more information.
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.