Oracle Database 12c: Advanced Administration — Question 73

Your database supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr

FROM v$instance_recovery -

Target_mttrestimated_mttr -
---------------------- ---------------------------
To ensure faster instance recovery, you set the fast_start_mttrjtargh:t initialization parameter to 30.
What is the effect of this setting on the database?

Answer options

• A. Automatic checkpoint tuning is disabled.
• B. The frequency of log switches is increased.
• C. The overhead on database performance is increased because of frequent writes to disk.
• D. The MTTR advisor is disabled.

Correct answer: A

Explanation

Setting the fast_start_mttr_target parameter to a specific value can lead to the disabling of automatic checkpoint tuning, which is why option A is correct. The other options are incorrect because they either describe effects that are not caused by this parameter or misinterpret its impact on database performance.