| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
| Property | Description | 
|---|---|
| Parameter type | Integer | 
| Default value | The number of logical CPUs reported by the operating system. | 
| Modifiable | ALTER SYSTEM | 
| Range of values | 0to operating system-specific | 
| Basic | No | 
Note:
TheRESOURCE_MANAGER_CPU_ALLOCATION parameter is deprecated. It is retained for backward compatibility only.RESOURCE_MANAGER_CPU_ALLOCATION specifies the number of CPUs that the Resource Manager should utilize. The Resource Manager controls how a system's CPUs are utilized by its database's sessions.
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.