Note
This view is available starting with V3.1.2.
Purpose
This view displays the resource management plan of the current active tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| ID | decimal(10,0) | NO | The ID of the resource plan. It is globally unique. |
| NAME | varchar(128) | NO | The name of the resource plan. |
| IS_TOP_PLAN | varchar(5) | NO | Indicates whether the current resource plan is the top-level plan. TRUE: The current resource plan is the top-level plan.FALSE: The current resource plan is a sub-plan of the top-level plan. In OceanBase Database, this value is fixed to TRUE. |
| CPU_MANAGED | varchar(3) | NO | Indicates whether the CPU usage is managed by a parameter. ON: The CPU usage is managed.OFF: The CPU usage is not managed. In OceanBase Database, this value is fixed to ON. |
| INSTANCE_CAGING | varchar(3) | NO | Reserved for compatibility. This value is fixed to NULL in OceanBase Database. |
| PARALLEL_SERVERS_ACTIVE | decimal(10,0) | NO | Reserved for compatibility. This value is fixed to NULL in OceanBase Database. |
| PARALLEL_SERVERS_TOTAL | decimal(10,0) | NO | Reserved for compatibility. This value is fixed to NULL in OceanBase Database. |
| PARALLEL_EXECUTION_MANAGED | varchar(32) | NO | Reserved for compatibility. This value is fixed to NULL in OceanBase Database. |
Sample query
Query the resource management plan of the current active tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.V$RSRC_PLAN;