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 To ensure faster instance recovery, youset 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 To ensure faster instance recovery, youset 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 5

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

Flame

Flame

C
FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified,
Once FAST_START_MTTR_TARGET is set, the database manages incremental checkpoint writes in an attempt to meet that target. If you have chosen a practical value for FAST_START_MTTR_TARGET, you can expect your database to recover, on average, in approximately the number of seconds you have chosen

Reply