DELETE_PLAN

The DELETE_PLAN procedure is used to delete a specified plan and all its associated plan directives.

Syntax

DBMS_RESOURCE_MANAGER.DELETE_PLAN (
    plan IN VARCHAR2);

Parameters

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

Examples

obclient> BEGIN 
  DBMS_RESOURCE_MANAGER.DELETE_PLAN('NIGHT');
END ;