how things happen in a commit process to redo log files

From: obakesan <>
Date: Fri, 16 May 2008 14:59:13 GMT
Message-ID: <5jhXj.179$>


as I understand things when a change occurs something writes the change from the database buffer cache to the redo log buffer. Then upon commit (I suppose its) LGWR copies these changes from the redo log buffer into the redo log files. But does it also write the rollback segment relevant to the transaction too?

If so, I'm not sure I see why it might be needed?


See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog:

please remove undies for reply Received on Fri May 16 2008 - 09:59:13 CDT

Original text of this message