Database Monitoring   «Prev  Next»
Lesson 12Buffer cache hit ratio scope
ObjectiveCompute the buffer cache hit ratio for a specific period of time.

Buffer cache hit Ratio Scope

The previous lesson on computing the buffer cache hit ratio focused on using statistics that have accumulated since the database was started. You may occasionally want to compute the buffer cache hit ratio for a specific period of time. You can do that by following the procedure shown in this Slide Show:
Buffer Cache 1
1) Buffer Cache 1
Buffer Cache 2
2) Buffer Cache 2
Buffer Cache 3
3) Buffer Cache 3
Buffer Cache 4
4) Buffer Cache 4
Buffer Cache 5
5) Buffer Cache 5
By computing the buffer cache hit ratio over a short period of time, you may notice variations that aren't apparent when you look at the cumulative hit ratio since the database was last opened. In the next lesson, you will monitor the efficiency of the shared pool.