Re: log file sync
- From: oracle@xxxxxxxxxxxx
- To: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- Date: Mon, 16 Oct 2006 11:45:30 -0400 (EDT)
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!
--
//www.freelists.org/webpage/oracle-l
Other related posts:
