|Lesson 12||Buffer cache hit ratio scope|
|Objective||Compute 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:
1) Buffer Cache 1
2) Buffer Cache 2
3) Buffer Cache 3
4) Buffer Cache 4
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.