DEVFYI - Developer Resource - FYI

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