Re: how things happen in a commit process to redo log files
Date: Fri, 16 May 2008 16:35:42 -0700 (PDT)
On May 16, 10:59 am, pellicleund..._at_hotmail.com (obakesan) wrote:
> 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
> please remove undies for reply
Have you looked at Tom Kyte's site ( http://asktom.oracle.com ) or the books he has written? Received on Fri May 16 2008 - 18:35:42 CDT