New Features for Administrators - Question 089

Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY, what is its effect?

A. The Advisory is on and will capture both CPU and memory overhead.

B. The Advisory is on but the memory for the Advisory is not allocated.

C. The Advisory is off and the memory for the Advisory is not allocated.

D. The Advisory is off but the memory for the Advisory remains allocated.

Answer: D

Explanation:

You must instruct Oracle to gather statistics on the buffer cache by setting the value of the DB_CACHE_ADVICE parameter to ON. The default value for this parameter is OFF. DB_CACHE_ADVICE can take on a third value, READY, which specifies that memory is allocated, but it does not gather statistics. The activity of collecting statistics affects the performance of the system. DB_CACHE_ADVICE is a dynamic parameter and can be changed to ON using ALTER SYSTEM command.

Incorrect Answers

A: The Advisory is off.

B: The Advisory is off.

C: The memory for the Advisory remains allocated.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 180-182 Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 16-17 Chapter 1: Oracle9i Database Administration and Management Features