how things happen in a commit process to redo log files

Hi

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?

thanks

See Ya
(when bandwidth gets better ;-)

Chris Eastwood
Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/

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