Database - RAC/Scalability (MOSC)

MOSC Banner

RACheck 2.1.6 fast_start_mttr_target = 0

edited Oct 16, 2012 10:58PM in Database - RAC/Scalability (MOSC) 3 commentsAnswered
Did run the latest 2.1.6 and one of the outcomes is the fast_start_mttr_target parameter which in my case was set to 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center