Feature
DBA_RSRC_PLANS displays all resource management plans defined in the system.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_RSRC_PLAN_DIRECTIVESV$RSRC_PLAN
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| PLAN_ID | NUMBER | NO | The ID of the resource plan. |
| PLAN | VARCHAR2(128) | NO | The name of the resource plan. |
| NUM_PLAN_DIRECTIVES | NUMBER | NO | The number of directives defined in the current resource plan. It is used only for compatibility and the value is fixed to NULL. |
| CPU_METHOD | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| MGMT_METHOD | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| ACTIVE_SESS_POOL_MTH | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| PARALLEL_DEGREE_LIMIT_MTH | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| QUEUING_MTH | VARCHAR2(128) | NO | It is used only for compatibility and the value is fixed to NULL. |
| SUB_PLAN | VARCHAR2(3) | NO | It is used only for compatibility and the value is fixed to NULL. |
| COMMENTS | VARCHAR2(2000) | YES | Comments for the resource plan. |
| 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. |