V$OB_UNITS

2024-03-05 01:54:26  Updated

Purpose

The V$OB_UNITS view provides information about the units on the current OBServer node.

Note

This view is introduced since OceanBase Database V4.0.0.

Columns

Column Type Nullable? Description
SVR_IP VARCHAR2(46) NO The IP address of the server.
SVR_PORT NUMBER(38) NO The port number of the server.
UNIT_ID NUMBER(38) NO The ID of the unit.
TENANT_ID NUMBER(38) NO The ID of the tenant to which the unit belongs.
ZONE VARCHAR2(128) NO The name of the zone.
MIN_CPU NUMBER(38) NO The minimum number of CPU cores.
MAX_CPU NUMBER(38) NO The maximum number of CPU cores.
MEMORY_SIZE NUMBER(38) NO The memory size, in bytes.
MIN_IOPS NUMBER(38) NO The minimum disk IOPS.
MAX_IOPS NUMBER(38) NO The maximum disk IOPS.
IOPS_WEIGHT NUMBER(38) NO The IOPS weight.
LOG_DISK_SIZE NUMBER(38) NO The size of the log disk.
LOG_DISK_IN_USE NUMBER(38) NO The used size of the log disk.
DATA_DISK_IN_USE NUMBER(38) NO The used size of the data disk.
STATUS VARCHAR2(64) NO The status of the unit. Valid values:
  • NORMAL: The data disk is normal.
  • MIGRATING IN: Data is being migrated into the unit.
  • MIGRATING OUT: Data is being migrated out of the unit.
  • MARK DELETING: The unit is marked as deleted.
  • WAIT GC: The unit is waiting for garbage collection (GC).
  • DELETING: GC has been completed, and the unit is being deleted.
  • ERROR: An error occurred.
  • CREATE_TIME NUMBER(38) NO The time when the unit was created on the OBServer node.

    Contact Us