Note
- This view was introduced in OceanBase Database V3.1.2.
- It is recommended to use the DBA_OB_RSRC_DIRECTIVES view to view the resource configuration parameters of a tenant in the Resource Manager.
Purpose
The DBA_RSRC_PLAN_DIRECTIVES view records the details of resource plan directives in the database.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| PLAN | VARCHAR2(128) | NO | The name of the resource plan to which the directive belongs. |
| GROUP_OR_SUBPLAN | VARCHAR2(128) | NO | The name of the resource group controlled by the directive. |
| TYPE | VARCHAR2(14) | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P1 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P2 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P3 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P4 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P5 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P6 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P7 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| CPU_P8 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P1 | NUMBER(38) | NO | The maximum percentage of CPU resources that can be used when the system is fully loaded. The default value is 100. |
| MGMT_P2 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P3 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P4 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P5 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P6 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P7 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MGMT_P8 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| ACTIVE_SESS_POOL_P1 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| QUEUEING_P1 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| PARALLEL_TARGET_PERCENTAGE | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| PARALLEL_DEGREE_LIMIT_P1 | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_GROUP | VARCHAR2(128) | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_FOR_CALL | VARCHAR2(5) | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_TIME | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_IO_MEGABYTES | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_IO_REQS | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_ESTIMATE | VARCHAR2(5) | NO | Reserved for compatibility. The value is always NULL. |
| MAX_EST_EXEC_TIME | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| UNDO_POOL | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MAX_IDLE_TIME | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MAX_IDLE_BLOCKER_TIME | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| MAX_UTILIZATION_LIMIT | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| PARALLEL_QUEUE_TIMEOUT | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_TIME_IN_CALL | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_IO_LOGICAL | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| SWITCH_ELAPSED_TIME | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| PARALLEL_SERVER_LIMIT | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| UTILIZATION_LIMIT | NUMBER(38) | NO | The maximum percentage of CPU resources that can be used by the resource group out of the total CPU resources of the tenant. The default value is 100, indicating that the resource group can use all CPU resources of the tenant. |
| PARALLEL_STMT_CRITICAL | VARCHAR2(12) | NO | Reserved for compatibility. The value is always NULL. |
| SESSION_PGA_LIMIT | NUMBER | NO | Reserved for compatibility. The value is always NULL. |
| PQ_TIMEOUT_ACTION | VARCHAR2(6) | NO | Reserved for compatibility. The value is always NULL. |
| COMMENTS | VARCHAR2(2000) | YES | Remarks about the directive. |
| STATUS | VARCHAR2(128) | NO | Reserved for compatibility. The value is always NULL. |
| MANDATORY | VARCHAR2(3) | NO | Reserved for compatibility. The value is always NULL. |