Skip to end of metadata
Go to start of metadata

The query corresponding to each monitoring element to check DIsk Buffer information is as follows.

Disk Buffer Hit Ratio

  • Main Column Description

HIT_RATIO(M)This means the rate at which pages already loaded in the disk buffer are reused since starting Altibase. The smaller this value, the more physical read pages are. If the number of physical reads is large, the system cannot process the query quickly. This column is the calculation of (get_pages + fix_pages - read_pages) / (get_pages + fix_pages).
  • No labels