how things happen in a commit process to redo log files
Date: Fri, 16 May 2008 14:59:13 GMT
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?
(when bandwidth gets better ;-)
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