What is the reason for having poor database performance if low value is set for the parameter FAST_START_MTTR_TARGET?

  • Interview Candidate
  • 3
  • 1212

Showing Answers 1 - 3 of 3 Answers

ianilreddy

  • Aug 7th, 2010
 

If we set low value for fast_start_mttr_target parameter it cause check points frequently.
If checkpoint occured dbwr writes dirty buffers to datafiles, before dbwr writes logwriter writes from redolog buffer to redolog files so that will cause poor database performance.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions