RACheck 2.1.6 fast_start_mttr_target = 0
I check the details from Raccheck together with the documenation and this is inconsitent... so who is right???? Rac check or the Oracle doc.
Accoording to Raccheck the default value for fast_start_mttr_target = 60, accoording to the docs the default is 0.
Check for parameter fast_start_mttr_target
Success FactorSQL DATA COLLECTIONS AND CHECKSRecommendation
Benefit / Impact: To optimize run time performance for write/redo generation intensive workloads. Increasing fast_start_mttr_target from the default will reduce checkpoint writes from DBWR processes, making more room for LGWR IO. Risk: Performance implications if set too aggressively (lower setting = more aggressive), but a trade-off between performance and availability. This trade-off and the type of workload needs to be evaluated and a decision made whether the default is needed to meet RTO objectives. fast_start_mttr_target should be set to the desired RTO (Recovery Time Objective) while still maintaing performance SLAs. So this needs to be evaluated on a case