Re: Solution for 01555

From: vlad <bulk_at_sfatcu.com>
Date: Thu, 23 Jan 2003 08:03:54 GMT
Message-ID: <KlNX9.5847$Ve4.1743@sccrnsc03>

Well, that's just groovy, because the rollback buffers cannot be reused anyway until the transaction that created them commits or rolls back.

vlad

"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns930BBD93265CESunnySD_at_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 Thu Jan 23 2003 - 02:03:54 CST