Proper logfile size in heavy i/o

Environment)

I use ORACLE v7.34, 70GB tablespace used on RS/6000 R50. I have a six logfiles and two members on each raid array. Each logfile size is 20MB. Haredware spec is 1GB RAM, 108GB HDD(RAID 5) and 4 cpu.

Situation)

It is used by groupware server program and system's average idle time is 74%, 24~48 log change occurred when normal stage. But in the evening I should delete many records in batch, log switching is occurred every 1 minute. The result is hard to serve clients. Idle time is 0%. This groupware is package. I have no source code and if I have a source code, it is not acceted by groupware vendor. So, deisn and applicatioin tunning is not possible. I increased SHARED_POOL_SIZE and all datafiles spread accross raid array.

Question)

I think log change is too often. So changed that makes checkpoint_interval is half of logfile size and checkpoint_timeout is 0. The result is good for performance and log chagne reduced. Should I change the checkpoint_interval greater than logfile size or change the logfile size greater than 20MB?

Thanks Received on Mon Dec 07 1998 - 20:29:03 CST