rob.boler@milto n-keynes.gov.uk (Rob Boler) wrote in message news:<6333cbba. 0308260645.54ef 2f32@posting.go ogle.com>...
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
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
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
will find these details in the CONCEPTS description. IIRC, you'll find
it in the Administrator's manual.
HTH
ed