Troubleshooting: Understanding and Tuning the Shared Pool
(Doc ID 62143.1)
Last updated on JANUARY 14, 2023
Oracle Database Backup Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Cloud Service - Version N/A and later Oracle Database - Personal Edition - Version 188.8.131.52 and later Oracle Database - Enterprise Edition - Version 184.108.40.206 and later Information in this document applies to any platform.
The aim of this article is to introduce the key issues involved in tuning the shared pool in Oracle 7 through 12c. The notes here are particularly important if your system shows any of the following:
Latch contention for the library cache latch/es or latch:library cache
Latch contention for the shared pool latch or latch:shared pool
High CPU parse times
High numbers of reloads in V$LIBRARYCACHE
High numbers of versions of cursors
Lots of parse calls
Frequent ORA-04031 errors
Ask Questions, Get Help, And Share Your Experiences With This Article
Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?
Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article. Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!