Re: how things happen in a commit process to redo log files

On May 16, 10:59 am, pellicleund..._at_hotmail.com (obakesan) wrote:
> 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

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