New Features for Administrators - Question 015

You can control instance recovery performance by setting parameters to define targets for _______.

A. The size of the redo buffer in the SGA

B. The instance that will perform recovery in a Real Application Clusters database

C. The number of blocks to be read during instance recovery, or the time needed to complete instance recovery

D. The number of passes through the redo logs made by the recovery process to identify blocks needing recovery

Answer: C

Explanation:

Oracle9i added the FAST_START_MTTR_TARGET parameter to define targets for the number of blocks to be read during instance recovery, or the time needed to complete instance recovery. Oracle internally uses the FAST_START_MTTR_TARGET parameter value to calculate and set the FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL parameters. If you specified the FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL parameter values, they will override the values Oracle calculates from the FAST_START_MTTR_TARGET parameter.

Incorrect Answers

A: You cannot control instance recovery performance by setting parameters to define targets for the size of the redo buffer in the SGA

B: It’s not possible to control instance recovery performance for the instance that will perform recovery in a Real Application Clusters database.

D: The number of passes through the redo logs made by the recovery process to identify blocks needing recovery will not help to control instance recovery performance.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 42-45

Chapter 2: Availability Enhancements

Oracle 9i New Features, Robert Freeman, p. 73-75

Chapter 3: New Oracle9i Availability and Recoverability Features