how things happen in a commit process to redo log files

Since 2001, over 90,000 cyclist's have joined Cycling Forums to discuss topics from general cycling to equipment, training, racing and travel or vacation destinations (especially in europe during the tour de france). We also feature an great deals in our online store, 100's of articles, classifieds and product reviews.

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