Purpose
The GV$OB_SERVERS view displays information about all OBServer nodes.
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. |
| ZONE | varchar(128) | NO | The name of the zone. |
| SQL_PORT | bigint(20) | NO | The SQL port number. |
| CPU_CAPACITY | bigint(20) | NO | The total CPU capacity of the OBServer node. |
| CPU_CAPACITY_MAX | double | NO | The overprovisioning value of the total CPU capacity for the OBServer node. It is subject to the resource_hard_limit parameter. The following rule applies: CPU_CAPACITY_MAX = CPU_CAPACITY * resource_hard_limit. |
| CPU_ASSIGNED | double | NO | The number of allocated CPU cores for the OBServer node. It is the sum of the MIN_CPU values of all units on the OBServer node. The following rule applies: CPU_ASSIGNED <= CPU_CAPACITY. |
| CPU_ASSIGNED_MAX | double | NO | The maximum number of allocated CPU cores for the OBServer node. It is the sum of the MAX_CPU values of all units on the OBServer node. The following rule applies: CPU_ASSIGNED_MAX <= CPU_CAPACITY_MAX. |
| MEM_CAPACITY | bigint(20) | NO | The available memory size for the observer process. |
| MEM_ASSIGNED | bigint(20) | NO | The allocated memory size for the OBServer node. It is the sum of the MEMORY_SIZE values of all units on the OBServer node. The following rule applies: MEM_ASSIGNED <= MEM_CAPACITY. |
| LOG_DISK_CAPACITY | bigint(20) | NO | The total size of the log disk. |
| LOG_DISK_ASSIGNED | bigint(20) | NO | The allocated space size of the log disk. It is the sum of the MAX_DISK_SIZE values of all units on the OBServer node. |
| LOG_DISK_IN_USE | bigint(20) | NO | The used size of the log disk. |
| DATA_DISK_CAPACITY | bigint(20) | NO | The total size of the data disk. |
| DATA_DISK_IN_USE | bigint(20) | NO | The used size of the data disk. |
| DATA_DISK_HEALTH_STATUS | varchar(20) | NO | The health status of the data disk. Valid values: NORMAL: The normal state.WARNING: A warning occurred.ERROR: An error occurred. |
| MEMORY_LIMIT | bigint(20) | NO | The available memory size for the observer process. |
| DATA_DISK_ABNORMAL_TIME | timestamp(6) | NO | The time when the last exception (WARNING) or error (ERROR) occurred on the data disk. |
| SSL_CERT_EXPIRED_TIME | timestamp(6) | NO | The expiration time of the SSL certificate used by the OBServer node when SSL is enabled on the node, as well as the UTC time, in microseconds. |