Database Reference
In-Depth Information
MTTR Advisor
The MTTR Advisor provides us with the information which
helps us in making changes to FAST_START_MTTR_TARGET
parameter setting of the database. This parameter enables the
Oracle Instance to take certain steps in terms of setting internal
triggers to achieve this mean time to recover. Remember that
setting Mean Time To Recover (MTTR) to a very low value may
reduce the crash recovery time but at the cost of lots of extra not
needed check points which may reduce the overall runtime
performance of the system. The V$MTTR_TARGET_ADVICE
dynamic performance view provides the statistics collected by
MTTR Advisor. MTTR stands for Mean-Time-To-Recover. To
enable MTTR Advisor set the STATISTICS_LEVEL to
TYPICAL or ALL and set the FAST_START_MTTR_TARGET
to non-zero value.
MTTR Advisor can be accessed through Advisor Central page.
The link to Advisor Central page is located on Home page under
Related Links section as shown in Figure 11-3.
Search WWH ::
Custom Search