Re: Chronological row-update procedure

rob.boler_at_milton-keynes.gov.uk (Rob Boler) wrote in message news:<6333cbba.0308260645.54ef2f32_at_posting.google.com>...
> Can anyone please direct me to a precise, concise, overview
> description of the chronological steps that Oracle goes through in
> updating a row?
>
> Ie: what is the interaction between the DB block buffers, re-do
> buffers, rollback buffers, datafiles, controlfiles, re-do logs, and
> rollback segments when a user makes a change to a row. (What gets
> done, to which of the above components, and at what moment?). Also, if
> a checkpoint is not part of the above procedure, where does it fit in,
> and what is the extra processing when it occurs?
>
> Ideally, I would like to know what happens for both a committed, and,
> a rolled-back update.
>
> Thanks in advance.
> Rob Boler

I commend your desire to really understand your tools. I think you will find these details in the CONCEPTS description. IIRC, you'll find it in the Administrator's manual.

HTH
   ed Received on Tue Aug 26 2003 - 19:45:08 CEST