Re: log file sync

On Sat, 14 Oct 2006, Stefan Knecht wrote:

> What's the size of your log_buffer and the size of your redo log files ?

Logs are 300MB. During the time the application is running the logs are switching every 7 to 10 minutes.

NAME                                 TYPE       VALUE

log_buffer                           integer    1572864
log_checkpoint_interval              integer    0
log_checkpoint_timeout               integer    1800

> Do you have any underscore parameters set ?

no, all generic.

I noticed that there are 6 groups, 1,2,3 on disk1 and 4,5,6 on disk2 (shortened for brevity). I'm beginning to think that part of the delays are due to group 2 being written to before 1 is finished, then getting backed up even more as group 3 is being written to while group 2 is still getting flushed and group 1 is still behind as well. I haven't tried it but i'm wondering if I should rearrange the groups so that each group would write to a different set of disks on each switch. I have some doubts that this is the ultimate fix but it wouldn't be extremely difficult to change and try.

Thanks!

--
http://www.freelists.org/webpage/oracle-l