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 | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node. |
| 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 the 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 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 | NUMBER(38) | NO | The time when the unit was created on the OBServer node. |