Troubleshooting: Understanding and Tuning the Shared Pool (Doc ID 62143.1)

Last updated on JANUARY 14, 2023

Applies to:

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 7.1.4.0 and later
Oracle Database - Enterprise Edition - Version 7.0.16.0 and later
Information in this document applies to any platform.

Purpose

Introduction

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.