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

Consistently getting ORA-04031 error

We are using Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64-bit production running on a Sun v880 server.

We persistently encounter the ORA-04031 error. Once the error occurred in the Forms, we couldn't make a connection in SQL*Plus or Forms anymore. In some instances, SQL*Plus connection is allowed but not on Forms. Is there any solution on this? We continuously increased the shared_pool_area and right now it is at 2.4 GB.
In almost all situations, a 2+ GB shared pool is too large. So I'd back this down quite a bit.

I strongly suggest that you apply the Oracle 9.2.0.4 patchset to your database. Prior versions had a problem where Oracle was not managing free space in the shared pool properly. This often resulted in the ORA-4031 errors and throwing more memory at the shared pool did not resolve the issue. Does this sound familiar? Apply the patchset and you should see your problems disappear.

This was last published in February 2004

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close