Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by redo log buffer ?
- 3 Answers
- 6959 Views
- I also Faced
- E-Mail Answers
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 |
What does LGWR do?
How will you monitor rollback segment status ?
How to find the SGA Size
What do Redo Log Buffers contain?
How will you create multiple rollback segments in a database ?
What is meant by free extent ?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is User Process?
How the space utilisation takes place within rollback segments?
What is the function of ARCH?
What is meant by recursive hints ?
What is a Parallel Server option in ORACLE?
Oracle General 
