Redo log waits in Oracle

Redo

Redo is written to disk when
User commits
Log Buffer 1/3 full (_log_io_size)
Log Buffer fills 1M
Every 3 seconds
DBWR asks LGWR to flush redo

http://www.oraclerealworld.com/redo-log-waits-in-oracle/

Advertisements