SWITCH LOGFILE vs ARCHIVE LOG CURRENT
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
Log Writer Process (LGWR)
How to Resize Redo Logs in Oracle
Resize Redo Logs The default size of redo logs during installation is 50MB which is too small for production databases. Of course, you can change… Read More »How to Resize Redo Logs in Oracle