Note
This view is available starting with V4.0.0.
Purpose
This view displays the information about the units of the OBServer node where the tenant is located. The system tenant can view the information about the units of all OBServer nodes in the cluster.
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 is located. Valid values:
NoteThis column is available starting with V4.2.0. |
| REGION | VARCHAR2(128) | NO | The name of the region to which the zone where the unit is located belongs. If this value is not set, the default value is default_region. If this value is NULL, it indicates that the value is invalid, which appears temporarily when the OBServer node restarts.
NoteThis column is available starting with V4.2.0. |
| MIN_CPU | NUMBER(38) | NO | The minimum CPU specification. |
| MAX_CPU | NUMBER(38) | NO | The maximum CPU specification. |
| MEMORY_SIZE | NUMBER(38) | NO | The size of memory, in bytes. |
| MIN_IOPS | NUMBER(38) | NO | The minimum IOPS specification. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS specification. |
| IOPS_WEIGHT | NUMBER(38) | NO | The IOPS weight. |
| LOG_DISK_SIZE | NUMBER(38) | NO | The size of the log disk, in bytes. |
| LOG_DISK_IN_USE | NUMBER(38) | NO | The size of the log disk that has been used, in bytes. |
| DATA_DISK_IN_USE | NUMBER(38) | NO | The size of the data disk that has been used, in bytes. |
| STATUS | VARCHAR2(64) | NO | The status of the unit. Valid values: NORMAL: Normal.MIGRATING IN: Migrating in.MIGRATING OUT: Migrating out.MARK DELETING: Marked for deletion.WAIT GC: Waiting for garbage collection.DELETING: Deleted after garbage collection.ERROR: Error. |
| CREATE_TIME | NUMBER(38) | NO | The time when the unit is created on the OBServer node. |
Sample query
Query the information about the units of all OBServer nodes where the current tenant is located.
obclient [SYS]> SELECT * FROM SYS.GV$OB_UNITS\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 172.xx.xx.xx
SVR_PORT: 2882
UNIT_ID: 1002
TENANT_ID: 1004
ZONE: zone1
ZONE_TYPE: ReadWrite
REGION: default_region
MIN_CPU: 2
MAX_CPU: 2
MEMORY_SIZE: 5368709120
MIN_IOPS: 9223372036854775807
MAX_IOPS: 9223372036854775807
IOPS_WEIGHT: 2
LOG_DISK_SIZE: 17394617549
LOG_DISK_IN_USE: 382315138
DATA_DISK_IN_USE: 18874368
STATUS: NORMAL
CREATE_TIME: 1722408674437600
1 row in set