This topic describes the RPC Network Latency monitoring metric for OceanBase tenants. You can specify the statistical range to query the RPC Network Latency of a tenant in a single zone or on a single OBServer node.
Metric description
The RPC network latency during the sampling period.
Metric parameters
Metric |
Metric name |
Unit |
|---|---|---|
| rpc_packet_net_delay | rpc_packet_net_delay | μs |
Calculation expression
sum(delta(ob_sysstat{stat_id="10005",@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(delta(ob_sysstat{stat_id="10006",@LABELS}[@INTERVAL])) by (@GBLABELS)
Collection SQL
For OceanBase Database V2.2.70 and later, but earlier than V4.0:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (10005, 10006) and (con_id > 1000 or con_id = 1) and class < 1000For OceanBase Database V4.0 and later:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (10005, 10006) and (con_id > 1000 or con_id = 1) and class < 1000