MTTR and Optimal Logfile Size
- From: Jeff C <backseatdba@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jan 2015 10:06:14 -0800
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
Other related posts:
