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

whoops

wrong place

sorry folks


See Ya
(when bandwidth gets better ;-)

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

please remove undies for reply