Macroblock Cache Size in OceanBase Shared Storage Mode

This topic describes the metrics related to the space occupied by the macroblock cache in OceanBase Database 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

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

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

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

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

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

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

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)