Chapter 43
Managing Multiple Buffer Pools in Oracle8
Michael R. Ault
The buffer cache is the area in memory where data is stored from data tables, indexes, rollback segments, clusters, and sequences. No data can get to users from a disk unless it goes through the Oracle db block buffers (except for special types of sorts). By ensuring that enough buffers are available for transient storage of these data items, execution can be expedited by reducing required disk reads.
Oracle7 and early Oracle8 releases had only the “normal” buffer area to worry with. Now, Oracle8i has added the capability to subdivide this buffer area into KEEP and RECYCLE buffer areas. Later we examine how these areas interact and how they should be tuned and sized.
Classic ...
Get Oracle Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
