首批通过分布式安全可靠测评,为关键业务系统打造
V$OB_RPC_OUTGOING
更新时间:2026-07-15 20:42:47
说明
该视图从 V4.0.0 版本开始引入。
功能描述
展示当前租户在当前 OBServer 节点上 RPC 的发送统计信息。
字段说明
| 字段名称 | 类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | 租户 ID |
| SVR_IP | varchar(46) | NO | 服务器IP 地址 |
| SVR_PORT | bigint(20) | NO | 服务器端口号 |
| PCODE | bigint(20) | NO | RPC Packet Code |
| PCODE_NAME | varchar(256) | NO | RPC Packet Code 对应的名称 |
| COUNT | bigint(20) | NO | 发送 RPC 的次数 |
| TOTAL_TIME | bigint(20) | NO | 总共花费时间,单位为微秒 |
| TOTAL_SIZE | bigint(20) | NO | 总共发送数据量大小,单位为字节 |
| FAILURE | bigint(20) | NO | 发送失败次数 |
| TIMEOUT | bigint(20) | NO | 发送超时次数 |
| SYNC | bigint(20) | NO | 同步等待 RPC 请求个数 |
| ASYNC | bigint(20) | NO | 异步回调 RPC 请求个数 |
| LAST_TIMESTAMP | timestamp(6) | NO | 最后更新统计信息时间 |
查询示例
用户租户下,查看本租户在当前节点发送的 RPC 请求,展示前 10 条记录。
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_RPC_OUTGOING LIMIT 10;
查询结果如下:
+-----------+----------------+----------+-------+-----------------+-------+------------+------------+---------+---------+------+-------+----------------------------+
| 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
相关视图或文档
查看当前租户在所有节点发送的 PRC 统计信息:GV$OB_RPC_OUTGOING
查看当前租户在当前节点收到的 RPC 的统计信息:V$OB_RPC_INCOMING