Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Log file switch (archiving needed)

722837Sep 17 2009 — edited Sep 29 2009

Hi,
My database is on windows 2003, 10.2.0.4, recently I have been getting the following wait events on a regular basis, LOG FILE SWITCH (ARCHIVING NEEDED)...My redo files are 50MB with 5 groups...I have changed the log_archive_max_process from 2 to 3, but still the problem persists...can anyone help me regarding the same?As to what other changes can be done?and this happens only during the time of BOD and EOD.

Thanks,
AJ

This post has been answered by Jonathan Lewis on Sep 21 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 27 2009

Added on Sep 17 2009

#general-database-discussions

17 comments

7,032 views