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.