String 

RESOURCE_MANAGER_PLAN = plan_name 

Dynamic. Scope = ALTER SYSTEM. 

None 

Any valid character string 

RESOURCE_MANAGER_PLAN specifies the top-level resource plan to use for this instance. The resource manager will load this top-level plan along with all its descendants (subplans, directives, and consumer groups). If you do not specify this parameter, the resource manager is off by default.  

You can change the setting of this parameter using the ALTER SYSTEM statement to turn on the resource manager (if it was previously off) or to turn off the resource manager or change the current plan (if it was previously on). If you specify a plan that does not exist in the data dictionary, Oracle returns an error message. 

See Also:

• Oracle8i Administrator's Guide for information on resource plans.

• Oracle8i Supplied PL/SQL Packages Reference for information on the DBMS_RESOURCE_MANAGER and DBMS_RESOURCE_MANAGER_PRIVS packages.

• "DBA_RSRC_PLANS", "DBA_RSRC_PLAN_DIRECTIVES", and the various V$RSRC_ dynamic performance views in Chapter 3 for information on existing resource plans.