Re: Log files in Online 5.x

cheryl, > Why so much log space? Recommendation is for physical and logical log is > 20% of your total configuration disk space. With a 3:1 ratio between the > logical and physical log space. If this is not correct (or if many of you > have found not to work), plese let me know. like most of the other parameters, these are guidelines to start out with. on my system, with my 60 logs, and LTXHWM at 50 and LTXEHWM at 60, the standard recommendations, i'm still seeing a few aborted long transactions a day. a percentage of these truly are long transactions that should be aborted, but a lot of them aren't. some of them ran fine on the 5.0 system, it seems that more data makes it into the log files under 7.X. so i still need to up the number of logs that i have. i will probably add another 10 log files today and see how that goes. mickm > On Thu, 18 Apr 1996, Mickey Mestel wrote: > > we have 7.11 running in an environment with ~70 sessions at a time, > > running mostly oltp and some dss. i have 60 log files, 1000k each, sitting > > in 2 dbspaces. the first dbspace has all the odd numbered logs, and the seco