Re: Logical Log Sizing

The actual log size is not as imporatant as the total span size of all logs. You'll need to gather the requirements of log space needed by your transactions (use onlog utility for this). I'd also suggest taking a peak period of activity to do your sizing for. -Bill > > We are using Online 5.06.UC1. > > When we first set up the database we made a decision to use a large number > of small logs (256 K) so they were frequently written to tape. We are now > finding we are getting some long transactions. > > We are probably looking to re-initialize with a new log size of 2Mb (or > possibly more), does anyone have any opinions/experience with logs of this > size or greater. > > Any feedback will be appreciated.