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

Cause of Oracle shared pool fragmentation error

What is the cause for the following error message and what preventive measure should be taken to avoid these kind of shared pool issues?

ORA-04031: Oracle shared pool fragmentation error

Correct sizing and configuration of the shared pool is essential to prevent this error. I recommend that you consult Oracle MetaLink document number 146599.1 for a thorough discussion of this topic.

Dig Deeper on Oracle database performance problems and tuning

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