Performance Tuning - Question 085

Which action could potentially cause checkpoints to take longer?

A. Increasing the number of redo log groups.

B. Increasing the size of rollback segments.

C. Decreasing the value of the REDO_LOG_BUFFERS parameter.

D. Increasing the value of the FAST_START_IO_TARGET parameter.

Answer: D

Explanation:

By increasing the FAST_START_IO_TARGET parameter you tell Oracle that it can use more time to perform recovery after instance crash. So it will cause that checkpoints will take longer. This parameter supersedes the FAST_START_MTTR_TARGET parameter if configured. The FAST_START_MTTR_TARGET init.ora parameter is used to specify a mean time (in seconds) to recover the instance following an instance failure.

Incorrect Answers

A: By increasing the number of redo log groups you will not decrease a time for checkpoints.

B: The size of rollback segments has nothing to do with checkpoints duration.

C: There is no REDO_LOG_BUFFERS parameter in Oracle.

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

Chapter 7: Tuning Redo Mechanisms