Purpose
V$RSRC_PLAN displays the active resource management plans of the tenant.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| ID | NUMBER | NO | The globally unique ID of the resource plan. |
| NAME | VARCHAR2(128) | NO | The name of the resource plan. |
| IS_TOP_PLAN | VARCHAR2(5) | NO | Indicates whether the current resource plan is the current top-level plan. Valid values: TRUE: The current resource plan is the current top-level plan.FLASE: The current resource plan is a subplan under the current top-level plan. At present, the value of this field is fixed at TRUE in OceanBase Database. |
| CPU_MANAGED | VARCHAR2(3) | NO | Indicates whether parameters for managing the CPU utilization have been configured in the current resource plan. Valid values: ON: Yes.OFF: No. At present, the value of this field is fixed at ON in OceanBase Database. |
| INSTANCE_CAGING | VARCHAR2(3) | NO | This field is used only for compatibility, and the value is fixed at NULL. |
| PARALLEL_SERVERS_ACTIVE | NUMBER | NO | This field is used only for compatibility, and the value is fixed at NULL. |
| PARALLEL_SERVERS_TOTAL | NUMBER | NO | This field is used only for compatibility, and the value is fixed at NULL. |
| PARALLEL_EXECUTION_MANAGED | VARCHAR2(32) | NO | This field is used only for compatibility, and the value is fixed at NULL. |