This topic describes the metrics related to the number of macroblocks warmed up in local cache in OceanBase Shared Storage (OB SS) mode.
Note
The following monitoring groups apply to OceanBase Shared Storage (SS) mode, requiring an OceanBase cluster version of ≥ 4.6.2.0. The collection condition is ob_mode_is_shared_storage (collected only in SS mode).
ob_ss_local_cache_major_compaction_prewarm_count
Metric description
The number of macroblocks warmed up during a major compaction in OB SS mode.
Parameter description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_local_cache_major_compaction_prewarm_count | ob_ss_local_cache_major_compaction_prewarm_count | - |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (240205) and (con_id > 1000 or con_id = 1)
ob_ss_local_cache_minor_compaction_prewarm_count
Metric description
The number of macroblocks warmed up during a minor compaction in OB SS mode.
Parameter description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_local_cache_minor_compaction_prewarm_count | ob_ss_local_cache_minor_compaction_prewarm_count | - |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (240213) and (con_id > 1000 or con_id = 1)
ob_ss_local_cache_scp_prewarm_count
Metric description
The number of macroblocks manually warmed up for hotspots in OB SS mode.
Parameter description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_local_cache_scp_prewarm_count | ob_ss_local_cache_scp_prewarm_count | - |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (240211) and (con_id > 1000 or con_id = 1)