MTTR and Optimal Logfile Size
From: Jeff C <backseatdba_at_gmail.com>
Date: Thu, 15 Jan 2015 10:06:14 -0800
Message-ID: <CAKsxbLpak3-6EESO0m3ukC4oij1iUW5LHhEOpYsiWL59KPG6-Q_at_mail.gmail.com>
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.
Date: Thu, 15 Jan 2015 10:06:14 -0800
Message-ID: <CAKsxbLpak3-6EESO0m3ukC4oij1iUW5LHhEOpYsiWL59KPG6-Q_at_mail.gmail.com>
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.
Thanks,
Jeff
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 15 2015 - 19:06:14 CET