InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is On-line Redo Log? |
|
Answer» The On-line Redo LOG is a set of TWO 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. The On-line Redo Log is a set of two 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. |
|