2.5 FAST_START_MTTR_TARGET
This enables you to specify the number of seconds the database takes to
perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is
overridden by LOG_CHECKPOINT_INTERVAL.
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 0 |
| Range of values | 0 to 3600 seconds |
| Recommended Values | 300 |
Oracle Banking Trade Finance relevance
If FAST_START_MTTR_TARGET is not set to 300 then run time performance for write/redo generation intensive workloads will not be optimized. This will reduce checkpoint writes from DBWR processes, making more room for LGWR IO. To optimize run time performance for write/redo generation intensive workloads, increase the FAST_START_MTTR_TARGET initialization parameter to 300.
Parent topic: Database Initialization Parameters