Note
- Due to the architectural optimization of the resource management feature in V4.x, this view is no longer applicable to V4.x. It was removed starting from V4.0.0.
- In V4.x, you can query the DBA_OB_UNITS and GV$OB_UNITS views to obtain the information about the units on the OBServer nodes in the cluster.
Purpose
The GV$UNIT view displays the metadata of all units in the cluster.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| unit_id | bigint(20) | NO | The ID of the unit. |
| unit_config_id | bigint(20) | NO | The ID of the unit specification. |
| unit_config_name | varchar(128) | NO | The name of the unit specification. |
| resource_pool_id | bigint(20) | NO | The ID of the resource pool. |
| resource_pool_name | varchar(128) | NO | The name of the resource pool. |
| zone | varchar(128) | NO | The zone to which the unit belongs. |
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| tenant_name | varchar(128) | NO | The name of the tenant. |
| svr_ip | varchar(32) | NO | The IP address. |
| svr_port | bigint(20) | NO | The port number. |
| migrate_from_svr_ip | varchar(32) | NO | The IP address of the server from which the unit is migrated. |
| migrate_from_svr_port | bigint(20) | NO | The port number of the server from which the unit is migrated. |
| max_cpu | double | NO | The maximum number of virtual CPU cores. |
| min_cpu | double | NO | The minimum number of virtual CPU cores. |
| max_memory | bigint(20) | NO | The maximum memory usage, in bytes. |
| min_memory | bigint(20) | NO | The minimum memory usage, in bytes. |
| max_iops | bigint(20) | NO | The maximum IOPS. |
| min_iops | bigint(20) | NO | The minimum IOPS. |
| max_disk_size | bigint(20) | NO | The maximum disk usage, in bytes. |
| max_session_num | bigint(20) | NO | The maximum number of sessions. |