Overview
Displays all system-defined resource management plans.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| PLAN_ID | decimal(10,0) | NO | Resource Plan ID |
| PLAN | varchar(128) | NO | Resource Plan Name |
| NUM_PLAN_DIRECTIVES | decimal(10,0) | NO | The number of directives defined in the current resource plan. This parameter is for compatibility only and its value is fixed as NULL |
| CPU_METHOD | varchar(128) | NO | For compatibility only. The current value is fixed as NULL |
| MGMT_METHOD | varchar(128) | NO | For compatibility only. The current value is fixed as NULL |
| ACTIVE_SESS_POOL_MTH | varchar(128) | NO | For compatibility only. The current value is fixed to NULL |
| PARALLEL_DEGREE_LIMIT_MTH | varchar(128) | NO | For compatibility only. The current value is fixed as NULL |
| QUEUING_MTH | varchar(128) | NO | For compatibility only. The current value is fixed as NULL |
| SUB_PLAN | varchar(3) | NO | For compatibility only. The current value is fixed to NULL |
| COMMENTS | varchar(2000) | YES | Remarks of the resource plan |
| STATUS | varchar(128) | NO | For compatibility only. The current value is fixed to NULL |
| MANDATORY | varchar(3) | NO | For compatibility only. The current value is fixed as NULL |
Sample query
The sys tenant queries all system-defined resource management plans.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_RSRC_PLANS;
The query result is as follows:
+---------+---------+---------------------+------------+-------------+----------------------+---------------------------+-------------+----------+----------+--------+-----------+
| PLAN_ID | PLAN | NUM_PLAN_DIRECTIVES | CPU_METHOD | MGMT_METHOD | ACTIVE_SESS_POOL_MTH | PARALLEL_DEGREE_LIMIT_MTH | QUEUING_MTH | SUB_PLAN | COMMENTS | STATUS | MANDATORY |
+---------+---------+---------------------+------------+-------------+----------------------+---------------------------+-------------+----------+----------+--------+-----------+
| NULL | daytime | NULL | NULL | NULL | NULL | NULL | NULL | NULL | TPFirst | NULL | NULL |
+---------+---------+---------------------+------------+-------------+----------------------+---------------------------+-------------+----------+----------+--------+-----------+
1 row in set
References
View various resource configuration parameters in the Resource Manager: DBA_OB_RSRC_DIRECTIVES
View the resource management plan of the current active tenant: V$RSRC_PLAN