As for the size, remember that you normally want some log switching: it allows the archlog to be generated (e.g. for standby) and forces a checkpoint, which would speed up an instance recovery. You may also want to limit the size to ease transmission of archlogs over the network. So the question here is: how frequently do you get a log switch with a 5MB file size? (and of course: how long is the wait? is it significant?)
Originally posted by hrishy
The wait event si significant as revealed by the statspack report.
Significant? (Remember, something has to be in the "top five waits". If your db & application are brilliantly tuned, with all data & parsed SQL in buffers, log switches & control file writes are about the only things left to wait on! ) So my question stands - how long do you wait for a switch?
If you're switching every 30 minutes, I would question why you are waiting that much. I would carefully look at smaller timeslices in your statspack reports (maybe 5 minutes or so) to see what is really going on.