What is the effect of this setting on the database?

Your database supports an OLTP workload. Examine the output of the query:SQL> SELECT target_mttr, estimated_mttrFROM v$instance_recoveryTarget_mttr estimated_mttr———————- ————————– 0 76To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.What is the effect of this setting on the database?Reference http://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

Question:

What is the effect of this setting on the database?

Options:

Automatic checkpoint tuning is disabled.

The frequency of log switches is increased.

The overhead on database performance is increased because of frequent writes to disk.

The MTTR advisor is disabled.

Correct Answer

The Correct Answer for this Question is

The overhead on database performance is increased because of frequent writes to disk.

You may also like...

Leave a Reply

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