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

How to empty your oracle recycle bin?

789


Is there any function in oracle similar like group_concat of mysql?

812


What is the data pump export utility?

856


How to convert raw data type into text in oracle? Explain

804


State the difference between a primary key and foreign key?

718


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4137


What is the difference between PFILE and SPFILE in Oracle?

788


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1781


How to export your connection information to a file?

827


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4919


How to estimate disk space needed for an export job?

773


Give the various exception types.

753


Describe varray?

842


What happens if the update subquery returns multiple rows?

828


Explain the use of show option in imp command.

847