What is On-line Redo Log?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
678. What is On-line Redo Log?
The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background process LGWR. The on-line redo log files are used in cyclical fashion.
(Continued on next question...)
Other Interview Questions