How to Drop Plans from the SQL Plan Management (SPM) Repository
(Doc ID 790039.1)
Last updated on MAY 19, 2022
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
The goal of the document is to provide steps for dropping plans from the SQL PLAN MANAGEMENT (SPM) REPOSITORY.
A potential reason for considering this might be a result of :
NOTE: The fix for this bug may allow purging to occur automatically.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Example 1: Drop all the plans associated with a particular sql_handle:|
|Example 2: Drop a baseline with a specific plan name|
|Example 3: Drop the entire SQL PLAN MANAGEMENT Repository|