Oracle教程 2023-04-09

Oracle 参数 RESOURCE_MANAGER_PLAN 官方解释，作用，如何配置最优化建议

本站中文解释

RESOURCE_MANAGER_PLAN参数在Oracle数据库中是一个基于资源管理的参数，可用于管理数据库的资源分配，以及控制数据库的I/O服务和进程服务等。该参数可以在实现高性能的情况下，按照优先级执行和调度数据库的资源。

RESOURCE_MANAGER_PLAN参数的正确设置应当满足以下要求：

1、资源管理器计划必须按照各类任务的优先级来分配。根据数据库任务的要求，可以把优先级高的任务分配到更强的资源，而优先级低的任务可以分配到更弱的资源。

2、必须确定资源管理器计划中涉及到的资源，以便更好地回收和分配这些资源。

3、确定资源管理器计划从而可以实现对I/O服务、存储分配以及多种数据库任务的优先级控制。

4、确定资源管理器计划所建设业务模型可以实现对I/O服务和进程服务等资源的有效重新分配。

正确设置RESOURCE_MANAGER_PLAN参数可以有效实现数据库资源的管理，从而提升数据库的性能和运行效率。

官方英文解释

RESOURCE_MANAGER_PLAN specifies the resource plan to use for a database (CDB or non-CDB).

Property	Description
Parameter type	String
Syntax	`RESOURCE_MANAGER_PLAN =` `resource_plan_name`
Default value	There is no default value.
Modifiable	`ALTER SYSTEM`
Modifiable in a PDB	Yes
Range of values	Any valid character string
Basic	No

In a CDB

In the root for a CDB, RESOURCE_MANAGER_PLAN specifies the CDB resource plan. A CDB resource plan allocates resources among PDBs.

A CDB resource plan is created using DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN and CREATE_CDB_PLAN_DIRECTIVE.

See Also:

Oracle Database
Administrator’s Guide for more information about using DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN and DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE
Oracle Database PL/SQL
Packages and Types Reference for more information about the CREATE_CDB_PLAN procedure and CREATE_CDB_PLAN_DIRECTIVE procedure for the DBMS_RESOURCE_MANAGER package

A session must be root to change the value of RESOURCE_MANAGER_PLAN for a CDB using the ALTER SYSTEM statement. For example, to enable and disable a CDB resource plan:

SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = CDB_resource_plan_name;
SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = '';

In a PDB, RESOURCE_MANAGER_PLAN specifies the PDB resource plan to use for the PDB.

A session must be in the PDB to enable or disable a PDB resource plan for that PDB. For example, to enable and disable a PDB resource plan:

SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = PDB_resource_plan_name;
SQL> ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = '';

In a PDB, the PDB resource plan has some restrictions compared to the resource plan of a non-CDB. The following restrictions apply to PDB resource plans:

A PDB resource plan cannot have subplans.
A PDB resource plan can have a maximum of eight consumer groups.
A PDB resource plan cannot have a multiple-level scheduling policy.

To enforce certain PDB resource plan policies, policies regarding resource allocation among PDBs should exist in the CDB resource plan. Without a CDB resource plan, certain PDB resource plan policies will not be enforced. If a PDB resource plan contains CPU or parallel statement queuing directives and a CDB resource plan is not specified, then Resource Manager will automatically enable the DEFAULT_CDB_PLAN plan. To prevent this behavior, set the RESOURCE_MANAGER_PLAN parameter at the root level to ORA$INTERNAL_CDB_PLAN.

Note:

See Oracle Database
Administrator’s Guide for information on CPU, I/O bandwidth, and parallel execution servers requirements in CDB resource plans, and for a description of the results in the PDB resource plans when those requirements are not met.

In a Non-CDB

RESOURCE_MANAGER_PLAN specifies the top-level resource plan to use for an instance in a non-CDB. The resource manager will load this top-level resource 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 resource plan (if it was previously on). If you specify a resource plan that does not exist in the data dictionary, Oracle returns an error message.

本站中文解释

官方英文解释

相关推荐