Performance Tuning - Question 103

Which statement about improving the performance of the database buffer cache by creating multiple buffer pools is true?

A. The KEEP buffer pool must also be deferred if the RECYCLE pool is defined.

B. The buffer pool for an object can be set explicitly only at object creation time.

C. The blocks from an object without an explicitly set buffer pool go into the RECYCLE pool.

D. Buffer pools are assigned to a segment, so option with multiple segments can have blocks in multiple buffer pools.

Answer: D

Explanation:

Oracle provides you with the ability to divide the Database Buffer Cache into as many as three separate areas called Buffer Pools. Segments are then explicitly assigned to use the appropriate Buffer Pool as determined by the DBA. Option with multiple segments can have blocks in multiple buffer pools.

Incorrect Answers

A: There is no such relation with the KEEP buffer pool and the RECYCLE buffer pool: they can be defined independently.

B: The buffer pool for an object can be changed after an object creation.

C: The blocks from an object without an explicitly set buffer pool go into the DEFAULT pool.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 265-274

Chapter 5: Tuning the Database Buffer Cache