Feature
DBA_RSRC_PLAN_DIRECTIVES displays details of each group of resource plan directives in the database
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_RSRC_PLANSV$RSRC_PLAN
Fields
| Field | 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 | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P1 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P2 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P3 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P4 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P5 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P6 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P7 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| CPU_P8 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P1 | NUMBER(38) | NO | The maximum CPU quota available in a full load scenario. |
| MGMT_P2 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P3 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P4 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P5 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P6 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P7 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_P8 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| ACTIVE_SESS_POOL_P1 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| QUEUEING_P1 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| PARALLEL_TARGET_PERCENTAGE | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| PARALLEL_DEGREE_LIMIT_P1 | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_GROUP | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_FOR_CALL | VARCHAR2(5) | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_TIME | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_IO_MEGABYTES | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_IO_REQS | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_ESTIMATE | VARCHAR2(5) | NO | It is used only for compatibility and the value is fixed to NULL. |
| MAX_EST_EXEC_TIME | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| UNDO_POOL | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MAX_IDLE_TIME | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MAX_IDLE_BLOCKER_TIME | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| MAX_UTILIZATION_LIMIT | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| PARALLEL_QUEUE_TIMEOUT | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_TIME_IN_CALL | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_IO_LOGICAL | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| SWITCH_ELAPSED_TIME | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| PARALLEL_SERVER_LIMIT | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| UTILIZATION_LIMIT | NUMBER(38) | NO | It is used only for compatibility and the value is fixed to NULL. |
| PARALLEL_STMT_CRITICAL | VARCHAR2(12) | NO | It is used only for compatibility and the value is fixed to NULL. |
| SESSION_PGA_LIMIT | NUMBER | NO | It is used only for compatibility and the value is fixed to NULL. |
| PQ_TIMEOUT_ACTION | VARCHAR2(6) | NO | It is used only for compatibility and the value is fixed to NULL. |
| COMMENTS | VARCHAR2(2000) | YES | Comments for the directive. |
| STATUS | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| MANDATORY | VARCHAR2(3) | NO | It is used only for compatibility and the value is fixed to NULL. |