Note
This view is available starting with V4.0.0.
Purpose
This view displays the statistics of RPC requests received by all tenants on the current OBServer node.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The IP address. |
| SVR_PORT | bigint(20) | NO | The port number. |
| PCODE | bigint(20) | NO | The RPC packet code. |
| PCODE_NAME | varchar(256) | NO | The name corresponding to the RPC packet code. |
| COUNT | bigint(20) | NO | The number of RPC requests of this type received. |
| TOTAL_SIZE | bigint(20) | NO | The total data received. |
| NET_TIME | bigint(20) | NO | The network time. |
| WAIT_TIME | bigint(20) | NO | The time from when the request was received to when it was placed in the queue. |
| QUEUE_TIME | bigint(20) | NO | The time spent waiting in the queue. |
| PROCESS_TIME | bigint(20) | NO | The actual processing time. |
| LAST_TIMESTAMP | timestamp(6) | NO | The time when the data was last updated. |
| DCOUNT | bigint(20) | NO | The request count for each Pcode RPC. The statistics are collected every 30 seconds. |
Sample query
In the sys tenant, query the statistics of all RPC requests received on the current node and find out which requests have a waiting time in the queue greater than 1 second.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_RPC_INCOMING WHERE QUEUE_TIME > 1000000;
The query result is as follows:
+-----------+----------------+----------+-------+---------------------------------+---------+------------+-----------+-----------+------------+--------------+----------------------------+--------+
| TENANT_ID | SVR_IP | SVR_PORT | PCODE | PCODE_NAME | COUNT | TOTAL_SIZE | NET_TIME | WAIT_TIME | QUEUE_TIME | PROCESS_TIME | LAST_TIMESTAMP | DCOUNT |
+-----------+----------------+----------+-------+---------------------------------+---------+------------+-----------+-----------+------------+--------------+----------------------------+--------+
| 1 | 11.xxx.xxx.xxx | 28825 | 258 | OB_RENEW_LEASE | 306831 | 76303890 | 20160603 | 696627 | 9424143 | 33429715 | 2025-03-26 16:21:17.894867 | 0 |
| 1 | 11.xxx.xxx.xxx | 28825 | 338 | OB_SEND_HEARTBEAT | 306816 | 15340800 | 21252279 | 4275695 | 8568262 | 24272822 | 2025-03-26 16:21:16.220454 | 4 |
| 1 | 11.xxx.xxx.xxx | 28825 | 1038 | OB_FETCH_LOCATION | 223970 | 4712687 | 15093533 | 2397657 | 5836348 | 11809672 | 2025-03-26 16:21:18.107840 | 4 |
| 1 | 11.xxx.xxx.xxx | 28825 | 1193 | OB_GET_LEADER_LOCATIONS | 613544 | 18406320 | 42290747 | 8597728 | 16618690 | 64087539 | 2025-03-26 16:21:17.710244 | 9 |
| 1 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 1227586 | 180455208 | 99509139 | 18785392 | 34736168 | 120744241 | 2025-03-26 16:21:17.972146 | 17 |
| 1 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 1227586 | 365822984 | 82736204 | 14992347 | 27140601 | 31330249 | 2025-03-26 16:21:17.972176 | 17 |
| 1001 | 11.xxx.xxx.xxx | 28825 | 4614 | OB_RUN_DBMS_SCHED_JOB | 702 | 55986 | 49278 | 9038 | 1172440 | 94751962 | 2025-03-26 16:08:04.686070 | 0 |
| 1001 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 1227399 | 180427719 | 87770500 | 20047105 | 34154755 | 117456112 | 2025-03-26 16:21:17.730479 | 17 |
| 1001 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 1227399 | 365764886 | 76654732 | 16092839 | 26850173 | 30910620 | 2025-03-26 16:21:17.730561 | 17 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 1859 | OB_GET_LS_REPLAYED_SCN | 1218888 | 29253312 | 72210515 | 15304479 | 34895276 | 84995561 | 2025-03-26 16:21:17.775105 | 18 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 1861 | OB_UPDATE_TENANT_INFO_CACHE | 609447 | 59725806 | 43222072 | 7944355 | 16208574 | 14019678 | 2025-03-26 16:21:17.920584 | 9 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 2454738 | 362073973 | 186193785 | 39158461 | 70169008 | 229388560 | 2025-03-26 16:21:17.871049 | 34 |
| 1002 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 2454738 | 732739263 | 159430349 | 31378602 | 54330759 | 60767457 | 2025-03-26 16:21:17.871186 | 34 |
| 1003 | 11.xxx.xxx.xxx | 28825 | 4614 | OB_RUN_DBMS_SCHED_JOB | 702 | 55986 | 60024 | 9886 | 1240180 | 99072125 | 2025-03-26 16:08:34.652085 | 0 |
| 1003 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 1227339 | 180418899 | 100036211 | 20396107 | 34554399 | 121591464 | 2025-03-26 16:21:17.650090 | 17 |
| 1003 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 1227339 | 365747006 | 82917476 | 16497429 | 27026369 | 31403647 | 2025-03-26 16:21:17.650172 | 17 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 1859 | OB_GET_LS_REPLAYED_SCN | 1218837 | 29252088 | 72037220 | 15659446 | 34808882 | 84720882 | 2025-03-26 16:21:17.775195 | 18 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 1861 | OB_UPDATE_TENANT_INFO_CACHE | 609421 | 59723258 | 43680094 | 8148469 | 16196226 | 14007657 | 2025-03-26 16:21:17.720856 | 8 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 4614 | OB_RUN_DBMS_SCHED_JOB | 54962 | 4452041 | 3663992 | 743115 | 3563193 | 619271964 | 2025-03-26 16:21:17.013583 | 1 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 2454618 | 362056273 | 171744365 | 37374627 | 70929909 | 217136098 | 2025-03-26 16:21:17.774323 | 34 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 2454618 | 732703443 | 147804811 | 30752819 | 54568431 | 58941676 | 2025-03-26 16:21:17.774387 | 34 |
| 1005 | 11.xxx.xxx.xxx | 28825 | 4614 | OB_RUN_DBMS_SCHED_JOB | 673 | 53668 | 44489 | 8723 | 1081054 | 88757221 | 2025-03-26 16:10:03.362899 | 0 |
| 1005 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 1176763 | 172984227 | 90555235 | 19881684 | 33814027 | 114105222 | 2025-03-26 16:21:17.693068 | 17 |
| 1005 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 1176763 | 350675358 | 76532346 | 15991260 | 26312719 | 29829027 | 2025-03-26 16:21:17.693162 | 17 |
| 1006 | 11.xxx.xxx.xxx | 28825 | 1859 | OB_GET_LS_REPLAYED_SCN | 1168630 | 28047120 | 68697482 | 15233621 | 33719065 | 81209831 | 2025-03-26 16:21:17.775109 | 18 |
| 1006 | 11.xxx.xxx.xxx | 28825 | 1861 | OB_UPDATE_TENANT_INFO_CACHE | 584318 | 57263164 | 41842668 | 7926729 | 15724543 | 13652752 | 2025-03-26 16:21:17.205143 | 8 |
| 1006 | 11.xxx.xxx.xxx | 28825 | 5386 | OB_LOG_ELECTION_ACCEPT_REQUEST | 2353465 | 347136206 | 159558942 | 37757337 | 68209576 | 217045220 | 2025-03-26 16:21:18.027842 | 34 |
| 1006 | 11.xxx.xxx.xxx | 28825 | 5387 | OB_LOG_ELECTION_ACCEPT_RESPONSE | 2353465 | 702509273 | 139511423 | 30820503 | 52426228 | 57509615 | 2025-03-26 16:21:18.027935 | 34 |
+-----------+----------------+----------+-------+---------------------------------+---------+------------+-----------+-----------+------------+--------------+----------------------------+--------+
28 rows in set
References
View the statistics of RPC requests received by all tenants on all nodes: GV$OB_RPC_INCOMING
View the statistics of RPC requests sent by all tenants on the current node: V$OB_RPC_OUTGOING