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 |
What is a deadlock in SQL? How can you prevent it?
How do we know whether an index is created on a table ???
What is the difference between alert log file and tarce file ?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
How to use fetch statement in a loop?
What is the difference between I and G in Oracle?
What is a cursor in oracle?
How to empty your oracle recycle bin?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is an Oracle sequence?
Differentiate between pre-select and pre-query?