When Does Lgwr Write To The Log File?

1.	When Does Lgwr Write To The Log File?
Answer» Following are the situations when LGWR writes to the log FILE: When a user process commits a transaction When redo log buffer is one-third FULL When more than a MEGABYTE of CHANGES are recorded into the redo log buffer Before DBWR writes modified blocks to the DATAFILES Following are the situations when LGWR writes to the log file:

Answer»

Following are the situations when LGWR writes to the log FILE:

Following are the situations when LGWR writes to the log file:

Discussion