Search notes:

Oracle: Init parameter FAST_START_MTTR_TARGET

Setting fast_start_mttr_target to non-zero value and statistics_level to typical or all enables the MTTR Advisory.

See also

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';
If specified, fast_start_mttr_target overrides the value of fast_start_mttr_target.
ORA-25530
MOS Note 2673186.1
init parameters

Index