Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Mon Oct 16 2006 - 10:45:30 CDT
![]() |
![]() |