The On-line Redo Log is a set of tow or more on-line redo files that record all committed  changes  made  to  the  database. Whenever a transaction is committed,  the  corresponding  redo entries temporarily stores in redo log buffers  of  the  SGA  are  written  to  an  on-line  redo  log file by the background ...

oracleofdelphi

 Profile Answers by oracleofdelphi Questions by oracleofdelphi

• Sep 9th, 2009

Online redologs name is used since archivelogs are called offline redologs. Online redologs can be in three states current to which lWr is currently writing transaction changes then this current beco...

samala

• Sep 15th, 2007

Redo logs records all the changes to the database  whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that...

Answer Question  Select Best Answer