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.