Re: Solution for 01555

From: Ban Spam <ban-spam_at_operamail.com>
Date: Thu, 23 Jan 2003 02:36:27 GMT
Message-ID: <Xns930BBD93265CESunnySD@68.6.19.6>

"vlad" <bulk_at_sfatcu.com> wrote in news:ZHpX9.84110$1q3.16415_at_sccrnsc01:

> I'm not sure why you say that "you'd have to do real-time updates of
> each SCN of every buffer in the buffer cache". If you are talking
> about the rollback buffers, I would assume that they get an SCN at the
> time the DML was executed that caused the creation of the rollback. If
> you mean the datafile buffers, those buffers should have an SCN as
> written into them by the last DML that modified them.

You "assume" wrong.
An SCN is generated/assigned only when a COMMIT is issued. Many, many INSERTs, UPDATEs and/or DELETES could have been issued many, many minutes before the COMMIT occurs & SCN has been generated/obtained. Received on Wed Jan 22 2003 - 20:36:27 CST