|
Explanation: Oracle 9i 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 Answer: 1: You cannot control instance recovery performance by setting parameters to define targets for the size of the redo buffer in the SGA 2: It’s not possible to control instance recovery performance for the instance that will perform recovery in a Real Application Clusters database. 3: 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. Reference: OCP Oracle 9i 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 Oracle 9i Availability and Recoverability Features
|