Databases Reference
In-Depth Information
In step 7, we calculate the Buffer Cache Hit Ratio, using statistics, to see how many reads
are resolved in the Buffer Cache. The results are shown in the following screenshot:
We can use the previous query to obtain a simple representation of how
the Buffer Cache is performing. To obtain more accurate information, we
can check the value for buffer gets in the AWR report.
We can also use other two Buffer Pools, other than the default one, named
KEEP
and
RECYCLE
. The former allows us to keep the buffers in the pool as long as possible, while the
latter can be used to store segments that are not allowed to interfere with other segments in
the Buffer Cache; this is used when they are only temporarily required.
