Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the statistics of RPC requests sent by all OBServer nodes.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | Server IP address |
| SVR_PORT | bigint(20) | NO | Server port |
| PCODE | bigint(20) | NO | RPC packet code |
| PCODE_NAME | varchar(256) | NO | Name of the RPC packet code |
| COUNT | bigint(20) | NO | Number of uses |
| TOTAL_TIME | bigint(20) | NO | Total time spent, in microseconds |
| TOTAL_SIZE | bigint(20) | NO | Total data sent, in bytes |
| FAILURE | bigint(20) | NO | Number of failures |
| TIMEOUT | bigint(20) | NO | Number of timeouts |
| SYNC | bigint(20) | NO | Number of synchronous RPC requests in the waiting queue |
| ASYNC | bigint(20) | NO | Number of asynchronous RPC requests |
| LAST_TIMESTAMP | timestamp(6) | NO | Last time the statistics were updated |
Sample query
In a user tenant, view the RPC requests sent by the tenant to all nodes, and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_RPC_OUTGOING LIMIT 10;
The query result is as follows:
+-----------+----------------+----------+-------+-----------------+-------+------------+------------+---------+---------+------+-------+----------------------------+
| TENANT_ID | SVR_IP | SVR_PORT | PCODE | PCODE_NAME | COUNT | TOTAL_TIME | TOTAL_SIZE | FAILURE | TIMEOUT | SYNC | ASYNC | LAST_TIMESTAMP |
+-----------+----------------+----------+-------+-----------------+-------+------------+------------+---------+---------+------+-------+----------------------------+
| 1002 | 11.xxx.xxx.xxx | 28825 | 1 | OB_TEST_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 2 | OB_TEST2_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 3 | OB_TEST3_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 4 | OB_TEST4_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 5 | OB_TEST5_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 6 | OB_TEST6_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 7 | OB_TEST7_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 8 | OB_TEST8_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 9 | OB_TEST9_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 16 | OB_ERROR_PACKET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
+-----------+----------------+----------+-------+-----------------+-------+------------+------------+---------+---------+------+-------+----------------------------+
10 rows in set
References
View the statistics of RPC requests sent by the current tenant to the current node: V$OB_RPC_OUTGOING
View the statistics of RPC requests received by the current tenant from all nodes: GV$OB_RPC_INCOMING