The DROP_SQL_PLAN_BASELINE procedure is used to drop one or more plan baselines.
Syntax
DBMS_SPM.DROP_SQL_PLAN_BASELINE (
database_name VARCHAR(65535),
sql_handle VARCHAR(65535),
plan_name VARCHAR(65535) DEFAULT NULL
)
RETURN DECIMAL;
Parameters
| Parameter | Description |
|---|---|
| database_name | The name of the database. This parameter is required only in MySQL-compatible mode. |
| sql_handle | The identifier of the SQL statement, which is also known as SQL_ID. |
| plan_name | The name of the plan, which is also known as the plan hash value. If the value is NULL, all evolving plans for the SQL statement are accepted. |
Examples
DECLARE
v_drop_plans number;
BEGIN
v_drop_plans := DBMS_SPM.DROP_SQL_PLAN_BASELINE(
sql_handle => '529F6E6454EF579C7CC265D1F6131D70',
plan_name => '3388268709115914355' );
END;
/