Feature
This view describes the active resource management plans of the tenant.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
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 to 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 to ON in OceanBase Database. |
| INSTANCE_CAGING | VARCHAR2(3) | NO | This field is used only for the purpose of compatibility, and the value is fixed at NULL. |
| PARALLEL_SERVERS_ACTIVE | NUMBER | NO | This field is used only for the purpose of compatibility, and the value is fixed at NULL. |
| PARALLEL_SERVERS_TOTAL | NUMBER | NO | This field is used only for the purpose of compatibility, and the value is fixed at NULL. |
| PARALLEL_EXECUTION_MANAGED | VARCHAR2(32) | NO | This field is used only for the purpose of compatibility, and the value is fixed at NULL. |