What is meant by redo log buffer ?

Answer Posted / deva

This buffer contains the information about the changes of
datablocks in the database buffer. While the redo log
buffer is filled during data modifications. The log writer
process wirtes information about the nmodifications to the
redo log files. These files are used after eg a system
crash in order to restore the database(database recovery)

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by an index?

611


What is merge in oracle?

550


Explain the difference between sql and oracle?

574


Can we use bind variables in oracle stored procedure?

480


What happens if the imported table already exists?

541






You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1449


How to drop an index in oracle?

596


Explain the use of file option in exp command.

591


How to set up autotrace for a user account?

586


Explain oracle’s system global area (sga).

613


How to grant create session privilege to a user in oracle?

560


what is the difference between substr and instr function in oracle?

578


How to use subqueries with the in operator using oracle?

600


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

549


How to export data with a field delimiter?

578