This topic describes the metric for monitoring the memory usage of an OceanBase Database tenant. You can specify a statistical range to query the memory usage in a single zone or on a single OBServer of an OceanBase Database tenant.
Definition
The memory usage of a tenant.
Description
| Metric | Metric name | Unit |
|---|---|---|
| memory_usage | ob_memory_percent | % |
Calculation expression
100 * avg(ob_sysstat{stat_id=“140003”,@LABELS}) by (@GBLABELS) / avg(ob_sysstat{stat_id=“140002”,@LABELS}) 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 (140003,140002) 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 (140003,140002) and (con_id > 1000 or con_id = 1) and class < 1000