An application accesses a small lookup table frequently. You notice that the required data blocks are
getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
A.
Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
B.
Increase the database buffer cache size.
C.
Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
D.
Configure Automata Shared Memory Management.
E.
Configure Automatic Memory Management
Explanation:
Schema objects are referenced with varying usage patterns; therefore, their cache behavior
may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP
buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from
consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that
object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been
assigned to one of the buffer pools.