Oracle Database 12c Advance Adminstration1z0-063 Test 2

Question : 35 of 40

Marks: +1, -0

Your database supports an OLTP workload. Examine the output of the query:

SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery  
   
 TARGET_MTTR ESTIMATED_MTTR 
 ----------- -------------- 
 0           76

To 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?

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.

Validate

Go to Question:

Prev Question

Next Question