What is the effect of this setting on the database?

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
———————- —————————
076
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?

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
———————- —————————
076
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?

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.

Show Hint

Leave a Reply 10

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

vijay

vijay

i think, C.
The overhead on database performance is increased because of frequent writes to disk.

setting fast_start_mttr_target to non-zero enables checkpoint tuning. (hence not A).

Reply

Edi

Edi

B correct.

Reply

edi

edi

sorry , B is correct
“A log switch implies a checkpoint will start. A checkpoint implies nothing about a log switch “

Reply

edi

edi

so sorry C is corect 🙂

Reply