OnLine Redo log configuration for OneWorld Xe

Guest

Guest
I'm looking for feedback on configurations of Oracle OnLine Redo logs in use
by you seasoned OneWorld users. Our logs are currently sized at 5Mb and we
have 4 groups. Switching however is occuring more frequently than is
"healthy" for the database, especially where our nightly batch jobs run so
I'm planning to resize the log files. It's probably a bit of a horses for
courses type query but I'm looking for some ideas as to sizes and number of
groups of online redo logs that folks have found work for them.

OneWorld Xe B7333 SP15.2 - Oracle 8.1.7 - W2K
-------------------------
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]
--------------------------------------------------------------------
This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.
--------------------------------------------------------------------
 
HI Dean
I have Oracle Database experience of 6-7 years. I have seen the redo log files size vary from 5m to 120M. It depends upon the activity in the database.
I agree Redo log switch should not occur frequently. I generally choose 3 redo log group and each group has 2 members on 2 different drives. As far as switching is concerned. I would say, it will be ok if redo log swicth every 1 hour(Maximum), I would recommend every 2 hour. If it is not the case then just count the no of switches that have occured in last one day. Multiply it with redo log file size to get the size and then devide it by the no of switch do you want to occur in the day to get the size of redo log file.

Hope this help.
Vivek Mohan
XE Update 3, Service Pack 18.1
Oracle 8.1.7.3.0, Windows NT Enterprise Server
 
Hello Sean,

Our logs are sized @ 20MB with 4 (or is it 5?) groups. At this size our heaviest batch job (MRP) switches about every 1-3 minutes. During the day it may be upto an hour before a switch occurs.

Regards,
 
Back
Top