Note
This view is introduced since OceanBase Database V4.0.0.
Purpose
This view displays the statistics of RPCs 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 times used |
| TOTAL_TIME | bigint(20) | NO | Total time spent in microseconds |
| TOTAL_SIZE | bigint(20) | NO | Total amount of data sent in bytes |
| FAILURE | bigint(20) | NO | Number of failed sends |
| TIMEOUT | bigint(20) | NO | Number of send timeouts |
| SYNC | bigint(20) | NO | Number of synchronous RPC requests waiting for responses |
| ASYNC | bigint(20) | NO | Number of asynchronous RPC requests |
| LAST_TIMESTAMP | timestamp(6) | NO | Last time statistics were updated |
Sample query
In the system tenant, query the RPC requests sent by tenant 1004 to all nodes, and display the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_RPC_OUTGOING WHERE TENANT_ID=1004 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 |
+-----------+----------------+----------+-------+-----------------+-------+------------+------------+---------+---------+------+-------+----------------------------+
| 1004 | 11.xxx.xxx.xxx | 28825 | 1 | OB_TEST_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 2 | OB_TEST2_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 3 | OB_TEST3_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 4 | OB_TEST4_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 5 | OB_TEST5_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 6 | OB_TEST6_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 7 | OB_TEST7_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 8 | OB_TEST8_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 9 | OB_TEST9_PCODE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1970-01-01 08:00:00.000000 |
| 1004 | 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 about the RPC requests sent by all tenants to the current node: V$OB_RPC_OUTGOING
View the statistics about the RPC requests received by all tenants from all nodes: GV$OB_RPC_INCOMING
