Note
This view is introduced since OceanBase Database V4.2.0.
Purpose
The V$OB_ARBITRATION_SERVICE_STATUS view displays the communication status between the current nodes of a tenant and the arbitration service.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The RPC port number of the OBServer node. |
| ARBITRATION_SERVICE_ADDRESS | VARCHAR2(512) | NO | The endpoint of the arbitration service. |
| STATUS | VARCHAR2(64) | NO | The communication status between the OBServer node and the arbitration service. Valid values:
|
Sample query
Check the communication status between the current nodes and the arbitration service of the tenant.
obclient[SYS]> SELECT * FROM SYS.V$OB_ARBITRATION_SERVICE_STATUS;
Here is the query result:
+----------------+----------+-----------------------------+--------+
| SVR_IP | SVR_PORT | ARBITRATION_SERVICE_ADDRESS | STATUS |
+----------------+----------+-----------------------------+--------+
| xxx.xx.xxx.207 | 2882 | xxx.xx.xxx.224:2882 | ACTIVE |
+----------------+----------+-----------------------------+--------+
1 row in set
References for reference
To view the arbitration members of the tenant, see GV$OB_ARBITRATION_MEMBER_INFO.
For more information about the arbitration service, see the following topics: