This topic describes the monitoring metrics related to the remote procedure call (RPC) package rt within an OceanBase Database tenant. You can specify a statistical period to query statistics about the Rpc package rt in a single zone or on a single OBServer of an OceanBase Database tenant.
in
Definition
The average time consumed in receiving an RPC packet within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| in | rpc_packet_in_rt | μs |
Calculation expression
(sum(rate(ob_sysstat{stat_id=“10005”,@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=“10006”,@LABELS}[@INTERVAL])) by (@GBLABELS)) / sum(rate(ob_sysstat{stat_id=“10000”,@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
If you use OceanBase Database of a version earlier than V4.0, execute the following statement:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (10005, 10006, 10000) and (con_id > 1000 or con_id = 1) and class < 1000If you use OceanBase Database V4.0 or later, execute the following statement:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (10005, 10006, 10000) and (con_id > 1000 or con_id = 1) and class < 1000
out
Definition
The average time consumed in sending an RPC packet within a tenant in the specified statistical period.
Description
| Metric | Metric field name | Unit |
|---|---|---|
| out | rpc_packet_out_rt | μs |
Calculation expression
(sum(rate(ob_sysstat{stat_id=“10005”,@LABELS}[@INTERVAL])) by (@GBLABELS) + sum(rate(ob_sysstat{stat_id=“10006”,@LABELS}[@INTERVAL])) by (@GBLABELS)) / sum(rate(ob_sysstat{stat_id=“10002”,@LABELS}[@INTERVAL])) by (@GBLABELS)
SQL statements for metric collection
If you use OceanBase Database of a version earlier than V4.0, execute the following statement:
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (10005, 10006, 10002) and (con_id > 1000 or con_id = 1) and class < 1000If you use OceanBase Database V4.0 or later, execute the following statement:
select /* MONITOR_AGENT */ con_id tenant_id, stat_id, value from v$sysstat where stat_id IN (10005, 10006, 10002) and (con_id > 1000 or con_id = 1) and class < 1000