What is meant by redo log buffer ?
Answers were Sorted based on User's Feedback
redo log buffer hold and written all redo entries in redo
log file or whenever a DML statement run that time redo
generate for that DML statement and these redo is hold by
the redo log buffer
every commit, log switch and before DBWN writer the redo
entries written into log file from redo buffer, it's
usefull for recovery purpose incase of crash
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / veeravel.csv@gmail.com
redo log file is stored to every transaction information, if you use sql query [eg: dml commands ]except select statement and then all write in redo buffer.it use to recovery purpose.
whenever give commit statement after will write in datafile..
[u will give rollback erase temporary statement]
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ravi dutta
when ever the buffer cache is crashed, the transactions
present in the buffer cache is lost. this can be recovered
by the redo log buffer, which contains all the transactions
present in the buffer cache
Is This Answer Correct ? | 1 Yes | 4 No |
Can a View based on another View in Oracle?
List the factors that can affect the accuracy of the estimations ?
What is the maximum size of a oracle9i database?
What is dictionary cache ?
How will you force database to use particular rollback segment?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is use of Rollback Segments In Database ?
How can you find the size of a database?
What are the two types of Server Configurations?
What is Shared SQL Area?
What does LGWR do?
What is the maximum number of Lock Processes used?