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