MTTR and Optimal Logfile Size

From: Jeff C <>
Date: Thu, 15 Jan 2015 10:06:14 -0800
Message-ID: <>

I set my fast_start_mttr_target to 3600 to get a baseline but I noticed that it suggest the optimal logfile size to 8561mb which seems very high. Currently my logfile size is 50mb and I have been getting a some more frequent log switch than in the past so I was going to increase it. And I never had mttr set so I set it to see what it suggest. But why would it suggest an 8gb log file? If I have 3 groups that is 24 gigs of a logs for a 30gb database.


Received on Thu Jan 15 2015 - 19:06:14 CET

Original text of this message