Note
This view is available starting with V3.1.2.
Purpose
V$RSRC_PLAN displays the resource management plans of the active tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| ID | NUMBER | NO | The ID of the resource plan. This value is globally unique. |
| NAME | VARCHAR2(128) | NO | The name of the resource plan. |
| IS_TOP_PLAN | VARCHAR2(5) | NO | Indicates whether the resource plan is the top-level plan: TRUE indicates that the resource plan is the top-level plan.FALSE indicates that the resource plan is a sub-plan of the top-level plan. In OceanBase Database, this value is always TRUE. |
| CPU_MANAGED | VARCHAR2(3) | NO | Indicates whether the CPU usage is managed by the resource plan: ON indicates that the CPU usage is managed.OFF indicates that the CPU usage is not managed. In OceanBase Database, this value is always ON. |
| INSTANCE_CAGING | VARCHAR2(3) | NO | This column is reserved for compatibility. Its value is always NULL. |
| PARALLEL_SERVERS_ACTIVE | NUMBER | NO | This column is reserved for compatibility. Its value is always NULL. |
| PARALLEL_SERVERS_TOTAL | NUMBER | NO | This column is reserved for compatibility. Its value is always NULL. |
| PARALLEL_EXECUTION_MANAGED | VARCHAR2(32) | NO | This column is reserved for compatibility. Its value is always NULL. |
Sample query
Query the resource management plans of the active user tenant.
obclient [SYS]> SELECT * FROM SYS.V$RSRC_PLAN;