Upgrade Oracle DBA 11g to Oracle Database 12c — Question 44

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 disables automatic checkpoint tuning, which is why option A is correct. Options B, C, and D are incorrect because they do not accurately describe the consequences of adjusting the fast_start_mttr_target parameter.