Prev Question
Next Question

Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttrestimated_mttr
———————- —————————
076
To ensure faster instance recovery, you set the fast_start_mttrtarget initialization parameter to
30.
What is the effect of this setting on the database?

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.

Explanation:

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *