Friday, March 13, 2009

RESOURCE_MANAGER_PLAN

Property

Description

Parameter type

String

Syntax

RESOURCE_MANAGER_PLAN = plan_name

Default value

There is no default value.

Modifiable

ALTER SYSTEM

Range of values

Any valid character string

RESOURCE_MANAGER_PLAN specifies the top-level resource plan to use for an 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.

Note:

1. See also

  • Oracle Database Administrator's Guide for information on resource plans
  • Oracle Database PL/SQL Packages and Types 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 Part III for information on existing resource plans

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = 'RESOURCE_MANAGER_PLAN';

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

resource_manager_plan

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

resource mgr top plan

Oracle initializatoin parameters