Re: how does oracle apply rollback?

Of course, changes may be buffered as usual... ;-)

Umberto

"Umberto Quaia" <umberto..quaia_at_tin.it> wrote:
> ...
> I don't know what you mean with "high level". For datafiles, each
> update starts immediately (it may be eventually rollbacked later).
> ...
> Umberto
>
>
> "Ryan Gaffuri" <rgaffuri_at_cox.net> wrote:
> > Does Oracle do a high level 'update' statement between the
rollback
> > data and the table. I would think that this would not be possible
> > since rollback is stored differently.
> >
> > what about redo? Or what about when you do an 'online' index
> rebuild,
> > someone else updates and when complete you need to apply the
> changes.
> >
> > anyone know how the algorithms differ from a generic update
> statement?
> >
> > I dont need to know. Im just curious.
>
>
Received on Sun Aug 03 2003 - 09:43:18 CDT