This topic describes the metrics related to the space occupied by the macroblock cache in OceanBase Database shared storage mode.
Note
The following monitoring groups apply to OceanBase Database in shared storage mode. The OceanBase cluster version must be ≥ 4.6.2.0. The collection condition is ob_mode_is_shared_storage (collected only in shared storage mode).
ob_ss_macro_cache_alloc_disk_size
Metric description
The disk space allocated for the macroblock cache in OceanBase Database shared storage mode.
Parameter description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_macro_cache_alloc_disk_size | ob_ss_macro_cache_alloc_disk_size | byte |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245058) and (con_id > 1000 or con_id = 1)
ob_ss_macro_cache_write_cache_size
Metric description
The disk space occupied by the write cache in OceanBase Database shared storage mode.
Parameter description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_macro_cache_write_cache_size | ob_ss_macro_cache_write_cache_size | byte |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245059) and (con_id > 1000 or con_id = 1)
ob_ss_macro_cache_meta_used_size
Metric description
The disk space occupied by Meta files (table_meta files) in OceanBase Database shared storage mode.
Parameter description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_macro_cache_meta_used_size | ob_ss_macro_cache_meta_used_size | byte |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245023) and (con_id > 1000 or con_id = 1)
ob_ss_macro_cache_tmp_file_used_size
Metric description
The disk space used by temporary files in OBSS mode.
Metric parameters
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_macro_cache_tmp_file_used_size | ob_ss_macro_cache_tmp_file_used_size | byte |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245029) and (con_id > 1000 or con_id = 1)
ob_ss_macro_cache_macro_used_size
Metric description
The disk space used by regular macroblocks in OBSS mode.
Metric parameters
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_macro_cache_macro_used_size | ob_ss_macro_cache_macro_used_size | byte |
SQL collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245035) and (con_id > 1000 or con_id = 1)
ob_ss_macro_cache_hot_macro_used_size
Metric description
The disk space used by hotspot tablet macroblocks in OBSS mode.
Metric parameters
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_macro_cache_hot_macro_used_size | ob_ss_macro_cache_hot_macro_used_size | byte |
SQL Collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245041) and (con_id > 1000 or con_id = 1)
ob_ss_mem_macro_cache_used_mem_size
Metric Introduction
The size of memory occupied by the macroblock cache in OBSS mode.
Metric Parameter Description
Metrics |
Metric Name |
unit |
|---|---|---|
| ob_ss_mem_macro_cache_used_mem_size | ob_ss_mem_macro_cache_used_mem_size | byte |
SQL Collection
select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ con_id tenant_id, stat_id, value
from v$sysstat
where stat_id IN (245060) and (con_id > 1000 or con_id = 1)