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 query resource configuration parameters of a tenant in the Resource Manager.
Purpose
The DBA_RSRC_PLAN_DIRECTIVES view records detailed information about resource plan directives in the database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| PLAN | VARCHAR2(128) | NO | The name of the resource plan to which the instruction belongs. |
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of the resource group controlled by the instruction. |
| TYPE | VARCHAR2(14) | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P1 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P2 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P3 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P4 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P5 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P6 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P7 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| CPU_P8 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P1 | NUMBER(38) | NO | The maximum CPU utilization when the system is at full load, with a default value of 100. |
| MGMT_P2 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P3 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P4 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P5 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P6 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P7 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MGMT_P8 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| ACTIVE_SESS_POOL_P1 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| QUEUEING_P1 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_TARGET_PERCENTAGE | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_DEGREE_LIMIT_P1 | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_GROUP | VARCHAR2(128) | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_FOR_CALL | VARCHAR2(5) | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_TIME | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_IO_MEGABYTES | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_IO_REQS | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_ESTIMATE | VARCHAR2(5) | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MAX_EST_EXEC_TIME | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| UNDO_POOL | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MAX_IDLE_TIME | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MAX_IDLE_BLOCKER_TIME | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| MAX_UTILIZATION_LIMIT | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_QUEUE_TIMEOUT | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_TIME_IN_CALL | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_IO_LOGICAL | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| SWITCH_ELAPSED_TIME | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| PARALLEL_SERVER_LIMIT | NUMBER | NO | This column is reserved for compatibility. Its value is fixed to NULL. |
| UTILIZATION_LIMIT | NUMBER(38) | NO | The upper limit of the percentage of CPU resources used by the resource group relative to the total CPU resources of the tenant. The default value is 100, which means that the tenant can use all of its CPU resources. |
| PARALLEL_STMT_CRITICAL | VARCHAR2(12) | NO | This parameter is for compatibility only. Its value is fixed to NULL. |
| SESSION_PGA_LIMIT | NUMBER | NO | This parameter is for compatibility only. Its value is fixed to NULL. |
| PQ_TIMEOUT_ACTION | VARCHAR2(6) | NO | This parameter is for compatibility only. Its value is fixed to NULL. |
| COMMENTS | VARCHAR2(2000) | YES | The remarks of the instruction. |
| STATUS | VARCHAR2(128) | NO | This parameter is for compatibility only. Its value is fixed to NULL. |
| MANDATORY | VARCHAR2(3) | NO | This parameter is for compatibility only. Its value is fixed to NULL. |
References
View all resource management plans: DBA_RSRC_PLANS
View the resource management plan of the current active tenant: V$RSRC_PLAN
View the resource configuration parameters of the tenant in Resource Manager: DBA_OB_RSRC_DIRECTIVES