Q
Problem solve Get help with specific problems with your technologies, process and projects.

Response to ORA-04031 error

I have received the ORA-04031 error. What is the size with which this parameter should be updated?

I have received the ORA-04031 error. What is the size with which this parameter should be updated?

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 9.2.0.6 or 9.2.0.7 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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close