2.339 RESOURCE_MANAGER_CPU_SCOPE

RESOURCE_MANAGER_CPU_SCOPE controls the scope of CPU resource management.

In previous releases, Oracle offered one method of CPU resource management, which operated within a database instance. Starting with Oracle Database 23ai, Oracle offers an alternative method for CPU resource management, which operates across all database instances on the server. This parameter allows you to choose between the two methods.

Property Description

Parameter type

String

Syntax

RESOURCE_MANAGER_CPU_SCOPE = { SERVER_WIDE | INSTANCE_ONLY }

Default value

INSTANCE_ONLY

Modifiable

No

Modifiable in a PDB

No

Basic

No

Oracle RAC

The same value must be used on all instances.

Values:

  • SERVER_WIDE - Enables server-level inter-instance CPU resource management

    Introduced in Oracle Database 23ai, this method can be used when multiple database instances share a Linux server. It enables CPU resource management across all database instances on the server. With this method, Oracle automatically configures Linux control groups (cgroups) with the desired CPU sharing and CPU utilization limits, and then places database sessions into the appropriate cgroups.

    In order to use this method, the following system and database requirements must be met:

    • This method requires the Linux operating system. It is supported on Oracle Autonomous Database, Oracle Database Exadata Cloud@Customer, Oracle Database Exadata Cloud Service, and on-premises Oracle Exadata systems. This method is not supported on non-Exadata Linux systems.

    • The server operating system must be Unbreakable Enterprise Kernel (UEK) version 5 or later.

    You can configure this method as follows:

    • Oracle Autonomous Database: All system and database requirements are installed and configured by default. RESOURCE_MANAGER_CPU_SCOPE is set to SERVER_WIDE by default.

    • Oracle Database Exadata Cloud@Customer: All system and database requirements are installed and configured by default. RESOURCE_MANAGER_CPU_SCOPE is set to INSTANCE_ONLY by default. You must set it to SERVER_WIDE if you want to use this method.

    • Oracle Database Exadata Cloud Service and on-premises Oracle Exadata systems: The Exadata image meets all system and database requirements. RESOURCE_MANAGER_CPU_SCOPE is set to INSTANCE_ONLY by default. You must set it to SERVER_WIDE if you want to use this method.

    When you specify the SERVER_WIDE setting, the value of the PROCESSOR_GROUP_NAME initialization parameter is ignored.

  • INSTANCE_ONLY - Enables CPU resource management only within the database instance.

    This is the method of CPU resource management used in releases prior to Oracle Database 23ai. It is supported on all Oracle Databases.

Note:

This parameter is available starting with Oracle Database 23ai.

See Also:

Oracle Database Administrator’s Guide for more information about setting this parameter