Purpose
The GV$OB_UNITS view provides information about the units on the OBServer node where the current tenant is located. You can view the units of all OBServer nodes in the current cluster from the sys tenant.
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. |
| ZONE_TYPE | VARCHAR2(128) | NO | The type of the zone where the unit resides. Valid values:
|
| REGION | VARCHAR2(128) | NO | The name of region where the zone of the unit resides. Valid values:
|
| 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 unit 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. |
