Re: Solution for 01555

Top posting is RUDE!

"vlad" <bulk_at_sfatcu.com> wrote in news:KlNX9.5847$Ve4.1743_at_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.

You are correct about the rollback buffer can not be reused, but this fact precludes an ORA-01555 from happening because of THIS transaction. Received on Fri Jan 24 2003 - 19:54:08 CST