How would you guarantee that the blocks for the table never age out?

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?

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.

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.



Leave a Reply 9

Your email address will not be published. Required fields are marked *


emavw

emavw

C is not correct

Dr. Oracle

Dr. Oracle

A, because it is the easiest and fastest way