Redo Log File

ALTER SYSTEM SWITCH LOGFILE vs ARCHIVE LOG CURRENT

by Ed Chen
February 26, 2020January 13, 2021

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 »

How to Change Redo Log Location in Oracle

by Ed Chen
February 22, 2020January 20, 2021

To improve overall performance, sometimes, we may consider to move redo logs to the location with faster disks, like Solid-State Drive (SSD). Once you decide… Read More »

How to Resize Redo Logs in Oracle

by Ed Chen
November 2, 2018January 13, 2021

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 »

Where to Change Redo Logs in DBCA or OUI

by Ed Chen
May 7, 2017January 18, 2021

The default size of redo log files is 50MB during database creation. It could be too small for databases with high volume transactions to switch… Read More »

How to Determine Archived Log Size

by Ed Chen
June 30, 2016April 8, 2019

Archived Log Size Before determining archived log size, you have to know that archived logs are derived (retired) from online redo logs switching. That is,… Read More »

When Redo Log Files Are All Missing

by Ed Chen
April 13, 2016October 2, 2019

If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let's… Read More »