1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. PROCESSOR_GROUP_NAME

1.283 PROCESSOR_GROUP_NAME

PROCESSOR_GROUP_NAME specifies the name of the processor group that this instance should run in.

Property Description

Parameter type

String

Syntax

PROCESSOR_GROUP_NAME = string

Default value

There is no default value

Modifiable

No

Modifiable in a PDB

No

Basic

No

Oracle RAC

For Oracle RAC databases, it is recommended that the operating system processor groups for each database instance are all named the same, so that the same PROCESSOR_GROUP_NAME value can be used. However, you can choose to use different names. In this case, you would set the PROCESSOR_GROUP_NAME explicitly for each database instance.

This initialization parameter is supported on the Linux and Solaris operating systems.

PROCESSOR_GROUP_NAME instructs the database instance to run itself within the specified operating system processor group. All Oracle processes will be bound to the CPUs in this group and will only run on these CPUs.

Notes:

  • Oracle recommends that this parameter be set only for databases on which the USE_DEDICATED_BROKER initialization parameter is also set to TRUE.

  • For NUMA systems, all SGA and PGA memory allocated by the database instance will be allocated from NUMA nodes within the group.

  • Starting with Oracle Database Appliance (ODA) release 19.9, you can use PROCESSOR_GROUP_NAME to specify the set of CPU cores on which the database on ODA will run. For more information, refer to Oracle Database Appliance X8-2 Deployment and User's Guide.

See Also: