What is On-line Redo Log?

Answer Posted / guest

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.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cold backup and hot backup (in case of oracle)?

675


Enlist some commands of dml?

712


What are the different types of data tables?

660


What is database host?

685


What is data abstraction in dbms?

787


Mention few case manipulation functions in sql

725


When we will denormalize data?

730


What is raid controller technology?

737


What is an image database?

695


Define a relation schema and a relation.

738


What is data sparsity and how it effect on aggregation?

700


Is the internet a database?

715


What are the different type of relationships in the dbms?

662


What do you mean by conflict serializability in dbms?

671


Explain by listing some major advantages of dbms.

650