Note
- This view is available starting with V3.1.2.
- For the current version, we recommend that you use the DBA_OB_RSRC_DIRECTIVES view to view the resource configuration parameters of a tenant in the Resource Manager.
Purpose
This view displays detailed information about each resource plan instruction in the database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PLAN | varchar(128) | NO | The name of the resource plan to which the instruction belongs. |
| GROUP_OR_SUBPLAN | varchar(128) | NO | The name of the resource group controlled by the instruction. |
| TYPE | varchar(14) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P1 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P2 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P3 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P4 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P5 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P6 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P7 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P8 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P1 | bigint(20) | NO | The maximum CPU utilization in percentage when the system is fully loaded. The default value is 100. |
| MGMT_P2 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P3 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P4 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P5 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P6 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P7 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P8 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| ACTIVE_SESS_POOL_P1 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| QUEUEING_P1 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_TARGET_PERCENTAGE | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_DEGREE_LIMIT_P1 | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_GROUP | varchar(128) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_FOR_CALL | varchar(5) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_TIME | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_IO_MEGABYTES | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_IO_REQS | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_ESTIMATE | varchar(5) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MAX_EST_EXEC_TIME | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| UNDO_POOL | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MAX_IDLE_TIME | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MAX_IDLE_BLOCKER_TIME | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| MAX_UTILIZATION_LIMIT | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_QUEUE_TIMEOUT | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_TIME_IN_CALL | decimal(10,0) | NO | This parameter is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_IO_LOGICAL | decimal(10,0) | NO | This column is for compatibility and is fixed to NULL. |
| SWITCH_ELAPSED_TIME | decimal(10,0) | NO | This column is for compatibility and is fixed to NULL. |
| PARALLEL_SERVER_LIMIT | decimal(10,0) | NO | This column is for compatibility and is fixed to NULL. |
| UTILIZATION_LIMIT | bigint(20) | NO | The maximum percentage of the tenant's total CPU resources that can be used by the resource group. The default value is 100, which means that the tenant can use all of its CPU resources. |
| PARALLEL_STMT_CRITICAL | varchar(12) | NO | This column is for compatibility and is fixed to NULL. |
| SESSION_PGA_LIMIT | decimal(10,0) | NO | This column is for compatibility and is fixed to NULL. |
| PQ_TIMEOUT_ACTION | varchar(6) | NO | This column is for compatibility and is fixed to NULL. |
| COMMENTS | varchar(2000) | YES | The remarks of the instruction. |
| STATUS | varchar(128) | NO | This column is for compatibility and is fixed to NULL. |
| MANDATORY | varchar(3) | NO | This column is for compatibility and is fixed to NULL. |
References
View all resource management plans: DBA_RSRC_PLANS
View the resource management plan for the current active tenant: V$RSRC_PLAN
View the resource configuration parameters for the tenant in Resource Manager: DBA_OB_RSRC_DIRECTIVES