V$RSRC_PLAN

2025-12-09 07:09:36  Updated

Feature

This view displays the active resource management plans of the tenant.

Fields

Field Type Nullable Description
ID decimal(10,0) NO The globally unique ID of the resource plan.
NAME varchar(128) NO The name of the resource plan.
IS_TOP_PLAN varchar(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 varchar(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 varchar(3) NO This field is used only for compatibility, and the value is fixed to NULL.
    PARALLEL_SERVERS_ACTIVE decimal(10,0) NO This field is used only for compatibility, and the value is fixed to NULL.
    PARALLEL_SERVERS_TOTAL decimal(10,0) NO This field is used only for compatibility, and the value is fixed to NULL.
    PARALLEL_EXECUTION_MANAGED varchar(32) NO This field is used only for compatibility, and the value is fixed to NULL.

    Contact Us