DELETE_PLAN_CASCADE Procedure

This procedure deletes the specified plan and all of its descendants (plan directives, subplans, consumer groups). Mandatory objects and directives are not deleted.

Syntax

DBMS_RESOURCE_MANAGER.DELETE_PLAN_CASCADE (
   plan IN VARCHAR2); 

Parameters

Table 53-5 DELETE_PLAN_CASCADE Procedure Parameters

Parameters	Description
plan	Name of plan.

Errors

If DELETE_PLAN_CASCADE encounters any error, then it rolls back, and nothing is deleted.

Note: If you want to use any default resource allocation method, then you do not need not specify it when creating or updating a plan.

Usage Notes

Defaults are:

• cpu_method = EMPHASIS

• parallel_degree_limit_mth = PARALLEL_DEGREE_LIMIT_ABSOLUTE

• active_sess_pool_mth = MAX_ACTIVE_SESS_ABSOLUTE

  Note: The parameter max_active_sess_target_mth is undocumented in this release: It is reserved for future use.