Same Results Both ALTER SYSTEM SWITCH LOGFILE and ALTER SYSTEM ARCHIVE LOG CURRENT force Log Writer process (LGWR) switch to the next redo log group… Read More »SWITCH LOGFILE vs ARCHIVE LOG CURRENT
Increase Redo Log Size The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can… Read More »How to Resize Redo Logs in Oracle