DELETE_PLAN

The DELETE_PLAN procedure is used to delete the specified plan and all plan directives it references.

Syntax

DBMS_RESOURCE_MANAGER.DELETE_PLAN (
    plan IN VARCHAR2);

Parameters

plan specifies the name of the resource plan to be deleted.

Examples

CALL DBMS_RESOURCE_MANAGER.DELETE_PLAN('NIGHT');
Query OK, 0 rows affected