Data Warehousing Question:

Download Job Interview Questions and Answers PDF

What is On-line Redo Log?

Data Warehousing Interview Question
Data Warehousing Interview Question

Answer:

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.

Download Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is Log Switch?Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the table space?