What is meant by redo log buffer ?
Answers were Sorted based on User's Feedback
Answer / guest
Redo log buffer is mermory where oracle server store all
the latest transaction which is made by the user.If RLB is
going to fill one third log writer writes the data from
redo log buffer to log file.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
What is different types of joins?
Can we write dml statement in function in oracle?
what is view?
What are the components of logical database structure in oracle database?
Why do we use coalesce function in oracle?
what is foreign key?
How to retrieve first and last records from a table?
Explain oracle instance.
Explain the use of rows option in exp command.
What do you mean by redo log file mirroring?
Explain the use of online redo log files in oracle.