fast_start_mttr_target to non-zero value and statistics_level to typical or all enables the MTTR Advisory. select estimated_mttr, target_mttr from v$instance_recovery; select * from v$mttr_target_advice; select * from v$statistics_level where statistics_name = 'MTTR Advice';
fast_start_mttr_target overrides the value of fast_start_mttr_target.