What Is On-line Redo Log?

1.	What Is On-line Redo Log?
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. 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.

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?