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…

The correct answer is A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause. 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…

New Features for Performance

Question

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?

Options

AConfigure the KEEP buffer pool and alter the table with the corresponding storage clause.
BIncrease the database buffer cache size.
CConfigure the RECYCLE bufferpool and alter the table with the corresponding storage clause.
DConfigure Automata Shared Memory Management.
EConfigure Automatic Memory Management-

How the community answered

(53 responses)

A
91% (48)
B
2% (1)
D
2% (1)
E
6% (3)

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.

Topics

#KEEP buffer pool#buffer cache#table pinning#storage clause

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice