Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays information about all OBServer nodes.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port of the server. |
| ZONE | varchar(128) | NO | The name of the zone. |
| SQL_PORT | bigint(20) | NO | The SQL port. |
| CPU_CAPACITY | bigint(20) | NO | The total CPU capacity of the node. |
| CPU_CAPACITY_MAX | double | NO | The overcommitted CPU capacity of the node. It is controlled by the resource_hard_limit parameter: CPU_CAPACITY_MAX = CPU_CAPACITY * resource_hard_limit. |
| CPU_ASSIGNED | double | NO | The number of CPUs allocated to the OBServer node. It is the sum of the MIN_CPU specifications of all units on the OBServer node. The following constraint applies: CPU_ASSIGNED <= CPU_CAPACITY. |
| CPU_ASSIGNED_MAX | double | NO | The upper bound of the number of CPUs allocated to the OBServer node. It is the sum of the MAX_CPU specifications of all units on the OBServer node. The following constraint applies: CPU_ASSIGNED_MAX <= CPU_CAPACITY_MAX. |
| MEM_CAPACITY | bigint(20) | NO | The total memory size available for tenant allocation on the OBServer node, which is calculated as memory_limit - system_memory, in bytes. |
| MEM_ASSIGNED | bigint(20) | NO | The memory size allocated to the OBServer node, which is the sum of the MEMORY_SIZE specifications of all units on the OBServer node, in bytes. The following constraint applies: MEM_ASSIGNED <= MEM_CAPACITY. |
| LOG_DISK_CAPACITY | bigint(20) | NO | The total size of the log disk space, in bytes. |
| LOG_DISK_ASSIGNED | bigint(20) | NO | The size of the log disk space allocated to the OBServer node, which is the sum of the LOG_DISK_SIZE specifications of all units on the OBServer node, in bytes. |
| LOG_DISK_IN_USE | bigint(20) | NO | The size of the log disk space used by the OBServer node, in bytes. |
| DATA_DISK_CAPACITY | bigint(20) | NO |
|
| DATA_DISK_ASSIGNED | bigint(20) | YES |
NoteThis field was introduced in V4.3.3. |
| DATA_DISK_IN_USE | bigint(20) | NO |
|
| DATA_DISK_HEALTH_STATUS | varchar(20) | NO | The health status of the data disk. NORMAL: normalWARNING: abnormalERROR: error |
| MEMORY_LIMIT | bigint(20) | NO | The total memory size available to the OBServer node, in bytes. |
| DATA_DISK_ALLOCATED | bigint(20) | NO | The size of the data disk allocated to the OBServer node, in bytes
NoteThis field was introduced in V4.2.0. |
| DATA_DISK_ABNORMAL_TIME | timestamp(6) | NO | The last time when the data disk was in the WARNING or ERROR state. |
| SSL_CERT_EXPIRED_TIME | timestamp(6) | NO | The expiration time of the SSL certificate in use on the OBServer node when SSL is enabled, in microseconds. |
| SS_DATA_DISK_OPERATION_SUGGESTED | varchar(32) | YES |
NoteFor OceanBase Database V4.3.5, this field is introduced starting from V4.3.5 BP2. |
| SS_DATA_DISK_SIZE_SUGGESTED | bigint(20) | YES |
NoteFor OceanBase Database V4.3.5, this field is introduced starting from V4.3.5 BP2. |
Sample query
In SN mode, query information about all OBServer nodes.
obclient> SELECT * FROM oceanbase.GV$OB_SERVERS\GThe query result is as follows:
*************************** 1. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 ZONE: zone1 SQL_PORT: 2881 CPU_CAPACITY: 64 CPU_CAPACITY_MAX: 64 CPU_ASSIGNED: 8 CPU_ASSIGNED_MAX: 8 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 18253611008 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 56103010304 LOG_DISK_IN_USE: 1140850688 DATA_DISK_CAPACITY: 179593805824 DATA_DISK_ASSIGNED: NULL DATA_DISK_IN_USE: 174063616 DATA_DISK_HEALTH_STATUS: NORMAL MEMORY_LIMIT: 107374182400 DATA_DISK_ALLOCATED: 179593805824 DATA_DISK_ABNORMAL_TIME: NULL SSL_CERT_EXPIRED_TIME: NULL SS_DATA_DISK_OPERATION_SUGGESTED: NULL SS_DATA_DISK_SIZE_SUGGESTED: NULL *************************** 2. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 ZONE: zone2 SQL_PORT: 2881 CPU_CAPACITY: 64 CPU_CAPACITY_MAX: 64 CPU_ASSIGNED: 8 CPU_ASSIGNED_MAX: 8 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 18253611008 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 56103010304 LOG_DISK_IN_USE: 1140850688 DATA_DISK_CAPACITY: 179593805824 DATA_DISK_ASSIGNED: NULL DATA_DISK_IN_USE: 174063616 DATA_DISK_HEALTH_STATUS: NORMAL MEMORY_LIMIT: 107374182400 DATA_DISK_ALLOCATED: 179593805824 DATA_DISK_ABNORMAL_TIME: NULL SSL_CERT_EXPIRED_TIME: NULL SS_DATA_DISK_OPERATION_SUGGESTED: NULL SS_DATA_DISK_SIZE_SUGGESTED: NULL *************************** 3. row *************************** SVR_IP: 172.xx.xxx.xxx SVR_PORT: 2882 ZONE: zone3 SQL_PORT: 2881 CPU_CAPACITY: 64 CPU_CAPACITY_MAX: 64 CPU_ASSIGNED: 8 CPU_ASSIGNED_MAX: 8 MEM_CAPACITY: 75161927680 MEM_ASSIGNED: 18253611008 LOG_DISK_CAPACITY: 179583320064 LOG_DISK_ASSIGNED: 56103010304 LOG_DISK_IN_USE: 1140850688 DATA_DISK_CAPACITY: 179593805824 DATA_DISK_ASSIGNED: NULL DATA_DISK_IN_USE: 174063616 DATA_DISK_HEALTH_STATUS: NORMAL MEMORY_LIMIT: 107374182400 DATA_DISK_ALLOCATED: 179593805824 DATA_DISK_ABNORMAL_TIME: NULL SSL_CERT_EXPIRED_TIME: NULL SS_DATA_DISK_OPERATION_SUGGESTED: NULL SS_DATA_DISK_SIZE_SUGGESTED: NULL 3 rows in setIn SS mode, query information about all OBServer nodes.
obclient> SELECT * FROM oceanbase.GV$OB_SERVERS\GThe query result is as follows:
*************************** 1. row *************************** SVR_IP: 11.xxx.xx.xx SVR_PORT: 41705 ZONE: zone1 SQL_PORT: 41704 CPU_CAPACITY: 8 CPU_CAPACITY_MAX: 8 CPU_ASSIGNED: 6 CPU_ASSIGNED_MAX: 6 MEM_CAPACITY: 7516192768 MEM_ASSIGNED: 5368709120 LOG_DISK_CAPACITY: 22548578304 LOG_DISK_ASSIGNED: 9663676416 LOG_DISK_IN_USE: 939524096 DATA_DISK_CAPACITY: 105226698752 DATA_DISK_ASSIGNED: 10737418240 DATA_DISK_IN_USE: 5401236272 DATA_DISK_HEALTH_STATUS: NORMAL MEMORY_LIMIT: 8589934592 DATA_DISK_ALLOCATED: 107374182400 DATA_DISK_ABNORMAL_TIME: NULL SSL_CERT_EXPIRED_TIME: NULL SS_DATA_DISK_OPERATION_SUGGESTED: NONE SS_DATA_DISK_SIZE_SUGGESTED: 0 *************************** 2. row *************************** SVR_IP: 11.xxx.xx.xx SVR_PORT: 41707 ZONE: zone2 SQL_PORT: 41706 CPU_CAPACITY: 8 CPU_CAPACITY_MAX: 8 CPU_ASSIGNED: 6 CPU_ASSIGNED_MAX: 6 MEM_CAPACITY: 7516192768 MEM_ASSIGNED: 5368709120 LOG_DISK_CAPACITY: 22548578304 LOG_DISK_ASSIGNED: 9663676416 LOG_DISK_IN_USE: 939524096 DATA_DISK_CAPACITY: 105226698752 DATA_DISK_ASSIGNED: 10737418240 DATA_DISK_IN_USE: 5388079920 DATA_DISK_HEALTH_STATUS: NORMAL MEMORY_LIMIT: 8589934592 DATA_DISK_ALLOCATED: 107374182400 DATA_DISK_ABNORMAL_TIME: NULL SSL_CERT_EXPIRED_TIME: NULL SS_DATA_DISK_OPERATION_SUGGESTED: NONE SS_DATA_DISK_SIZE_SUGGESTED: 0 *************************** 3. row *************************** SVR_IP: 11.xxx.xx.xx SVR_PORT: 41709 ZONE: zone3 SQL_PORT: 41708 CPU_CAPACITY: 8 CPU_CAPACITY_MAX: 8 CPU_ASSIGNED: 6 CPU_ASSIGNED_MAX: 6 MEM_CAPACITY: 7516192768 MEM_ASSIGNED: 5368709120 LOG_DISK_CAPACITY: 22548578304 LOG_DISK_ASSIGNED: 9663676416 LOG_DISK_IN_USE: 939524096 DATA_DISK_CAPACITY: 105226698752 DATA_DISK_ASSIGNED: 10737418240 DATA_DISK_IN_USE: 5389022000 DATA_DISK_HEALTH_STATUS: NORMAL MEMORY_LIMIT: 8589934592 DATA_DISK_ALLOCATED: 107374182400 DATA_DISK_ABNORMAL_TIME: NULL SSL_CERT_EXPIRED_TIME: NULL SS_DATA_DISK_OPERATION_SUGGESTED: NONE SS_DATA_DISK_SIZE_SUGGESTED: 0 3 rows in set
References
To view information about the current OBServer node, see V$OB_SERVERS.
For more information about how to query nodes, see View an OBServer node.
