RESOURCE_MANAGER_CPU_ALLOCATION
RESOURCE_MANAGER_CPU_ALLOCATION specifies the number of CPUs that the Resource Manager should use. The Resource Manager controls how a system’s CPUs are utilized by its database’s sessions.
Note: The RESOURCE_MANAGER_CPU_ALLOCATION parameter is deprecated and its value is ignored. This parameter is retained only for backward compatibility. Use the CPU_COUNT parameter instead.
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 0 |
| Modifiable | ALTER SYSTEM |
| Modifiable in a PDB | No |
| Range of values | 0 to operating system-specific |
| Basic | No |
The Resource Manager schedules database sessions on the CPUs according to a resource plan that has been configured and enabled by the DBA. Normally, the Resource Manager schedules enough database sessions to keep all CPUs utilized. However, in some scenarios, a DBA may only want to schedule enough database sessions to keep a subset of the CPUs utilized.
See Also: “CPU_COUNT”