Purpose
The GV$OB_UNITS view displays information about the units on the OBServer nodes where a tenant is located. You can view the units on 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 | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| UNIT_ID | bigint(20) | NO | The ID of the unit. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the unit belongs. |
| ZONE | varchar(128) | NO | The name of the zone. |
| ZONE_TYPE | varchar(128) | NO | The type of the zone where the unit resides. Valid values:
|
| REGION | varchar(128) | NO | The name of the region where the zone of the unit resides. Valid values:
|
| MAX_CPU | double | NO | The maximum number of CPU cores. |
| MIN_CPU | double | NO | The minimum number of CPU cores. |
| MEMORY_SIZE | bigint(20) | NO | The memory size, in bytes. |
| MAX_IOPS | bigint(20) | NO | The maximum disk IOPS. |
| MIN_IOPS | bigint(20) | NO | The minimum disk IOPS. |
| IOPS_WEIGHT | bigint(20) | NO | The IOPS weight. |
| LOG_DISK_SIZE | bigint(20) | NO | The size of the log disk. |
| LOG_DISK_IN_USE | bigint(20) | NO | The used size of the log disk. |
| DATA_DISK_IN_USE | bigint(20) | NO | The used size of the data disk. |
| STATUS | varchar(64) | NO | The status of the unit. Valid values: NORMAL: The normal state.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 | timestamp(6) | NO | The time when the unit was created on the OBServer node. |
