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.
Configure Automatic Memory Management



Leave a Reply 4

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


Voeurng Sovann

Voeurng Sovann

The answer is A and C