Skip to Main Content

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!

REDO LOGS FREQUENT SWITCHING

939393Aug 29 2011 — edited Aug 29 2011
Hi,

My database is Oracle 10g R2 and we are using it on windows server 2003. As this database is mainly used for data loading and generating reports but what i saw in alert log file that redo log switching is very frequent. Normal switching will take approx 30-1 hr but my redo log switch after 5 -10 mins. Is this will affect the performance.

My log file size is 250MB 2 No's. What i need to do in this scenerio.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2011
Added on Aug 29 2011
28 comments
1,719 views