QUESTION 51-KEEP buffer pool

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-
Correct Answer: A

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.

 

应用程序经常访问一个小型查找表。您注意到，所需的数据块正在从默认的缓冲区缓存中老化。

如何保证表的块永远不会老化?

A.配置KEEP缓冲池，用对应的storage子句修改表。

B.增加数据库缓冲区缓存大小。

C.配置RECYCLE buffer pool，用对应的storage子句修改表。

D.配置Automata共享内存管理。

E.配置自动内存管理—

正确答案:

 

 

模式对象被不同的使用模式引用;因此，它们的缓存行为可能完全不同。多个缓冲池使您能够解决这些差异。您可以使用KEEP缓冲池来维护缓存中的对象，也可以使用RECYCLE缓冲池来防止对象在缓存中占用不必要的空间。当一个对象被分配到缓存中时，该对象的所有块都被放置在缓存中。对于没有被分配到其中一个缓冲池的对象，Oracle会维护一个默认的缓冲池。