Note
This view is available starting with V4.0.0.
Purpose
This view displays the unit information of the OBServer node where the tenant is located. The sys tenant can view the unit information 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 to which the unit belongs. Valid values:
NoteThis column is available starting with V4.2.0. |
| REGION | VARCHAR2(128) | NO | The name of the region to which the zone belongs. If this column is not set, the default value is default_region. If the value is NULL, it indicates that the value of this column is invalid. This value appears temporarily when an 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. |
| MAX_NET_BANDWIDTH | NUMBER(38) | YES | The maximum network bandwidth of the unit, in bytes.
NoteThis column is available starting with V4.3.4. |
| NET_BANDWIDTH_WEIGHT | NUMBER(38) | YES | The weight of the network bandwidth of the unit.
NoteThis column is available starting with V4.3.4. |
| 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_SIZE | NUMBER(38) | YES |
NoteThis column is available starting with V4.3.4. |
| DATA_DISK_IN_USE | NUMBER(38) | NO |
|
| STATUS | VARCHAR2(64) | NO | The status of the unit. Valid values:
|
| CREATE_TIME | NUMBER(38) | NO | The creation time of the unit on the OBServer node. |
| REPLICA_TYPE | VARCHAR2(7) | NO | The replica type, which defaults to FULL.
Note
|
Sample query
In SN mode, a user tenant queries the unit information of all OBServer nodes where it resides.
obclient [SYS]> SELECT * FROM SYS.GV$OB_UNITS\G
The query result is as follows:
*************************** 1. row ***************************
SVR_IP: 172.xx.xxx.xxx
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
MAX_NET_BANDWIDTH: 9223372036854775807
NET_BANDWIDTH_WEIGHT: 2
LOG_DISK_SIZE: 17394617549
LOG_DISK_IN_USE: 1751668778
DATA_DISK_SIZE: NULL
DATA_DISK_IN_USE: 29081600
STATUS: NORMAL
CREATE_TIME: 1730257207614632
REPLICA_TYPE: FULL
1 row in set
References
Query the unit information on the current node: V$OB_UNITS.
For more information about tenant resources, see View tenant and resource information.