What is MTTR advisor in Oracle?
Sapna Malik
Mean Time To Recover Advisor
The MTTR means Mean Time to Recover in Oracle. Lets you configure instance recovery by enabling you to adjust the mean time to recovery setting for an instance. The MTTR advisory is available to help you evaluate the effect of different MTTR settings on system performance in terms of extra physical writes. The mean time for recovery from a system failure is specified based on business needs by the database administrator using enterprise manager and then needed reconfiguration of Oracle components automatically task place. The FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance.
The MTTR means Mean Time to Recover in Oracle. Lets you configure instance recovery by enabling you to adjust the mean time to recovery setting for an instance.
The MTTR advisory is available to help you evaluate the effect of different MTTR settings on system performance in terms of extra physical writes. The mean time for recovery from a system failure is specified based on business needs by the database administrator using enterprise manager and then needed reconfiguration of Oracle components automatically task place. The FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance.