Log Writer Process (LGWR)

ALTER SYSTEM SWITCH LOGFILE vs ARCHIVE LOG CURRENT

by Ed Chen
February 26, 2020October 31, 2022

Same Results Both SWITCH LOGFILE and ARCHIVE LOG CURRENT force Log Writer process (LGWR) switch to the next redo log group and start to write,… Read More »

How to Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018March 21, 2023
4 Comments

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 »