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 configuration for Data Warehouse

Hi, I,m new to oracle database administration and this is my first post
I need guidance on redo logs configuration for data warehouse. The issue I'm facing is that during the loading phase heavy logswitch occurs (every 30 sec) and the loading is very slow because there is frequent waiting, I'm seeing below events in v$session

1.log file switch (checkpoint incomplete)
2.db file async I/O submit

Current redo log groups 5 with 2 members each, Size 512M
Database is in noarchivelog mode

pleas let me know if any more info is required

Comments
Post Details
Added on Jun 25 2025
7 comments
158 views