ORA-4031 and DBMS_SHARED_POOL.KEEP remarks and PIND toolkit overview
(Doc ID 311689.1)
Last updated on JUNE 30, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Cloud Schema Service - Version N/A and later Information in this document applies to any platform.
Purpose
This article contains information about DBMS_SHARED_POOL.KEEP (Keeping) which can help when dealing with ORA-4031. Anyway we recommend firstly to follow documents: <Note 62143.1> - Understanding and Tuning the Shared Pool <Note 146599.1> - Diagnosing and Resolving Error ORA-04031 and try to reduce pressure put on Library Cache.
It also intends to give some information on PIND toolkit which helps to resolve some ORA-4031 problems. PIND toolkit itself is available in Published (Limited) Note 301171.1 - Toolkit for dynamic marking of Library Cache objects as Kept (PIND)
Scope
This document is intended for DBAs.
Details
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!