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

Other related posts: