The query corresponding to each monitoring element to check DIsk Buffer information is as follows.
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). |