This topic describes monitoring metrics related to the remote procedure call (RPC) packet throughput within an OceanBase Database tenant. These metrics collect statistics on the amount of data in the RPC packets sent and received within a tenant in a statistical period . You can specify a statistical period to query statistics about the RPC packet throughput in a single zone or on a single OBServer of an OceanBase Database tenant.
in
Definition
The total amount of data in the RPC packets received within a tenant in a statistical period .
Description
| Metric | Metric field name | Unit |
|---|---|---|
| in | rpc_packet_in | Byte |
Calculation expression
sum(rate(ob_sysstat{stat_id="10001",@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 (10001) 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 (10001) and (con_id > 1000 or con_id = 1) and class < 1000
out
Definition
The total amount of data in the RPC packets sent within a tenant in a statistical period .
Description
| Metric | Metric field name | Unit |
|---|---|---|
| out | rpc_packet_out | Byte |
Calculation expression
sum(rate(ob_sysstat{stat_id="10003",@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 (10003) 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 (10003) and (con_id > 1000 or con_id = 1) and class < 1000