Re: Fwd: Snapshot too old from READ-ONLY table (data pump export)
Date: Tue, 19 Jul 2011 11:36:24 +0300
Message-ID: <OF3FB20A8F.C431A574-ONC22578D2.002DA8F9-C22578D2.002F48AB_at_seb.lt>
Since the question was raised again, does anyone know the latest, up-do-date explanation on how oracle multi versioning works.
ITL's, commit SCN's, row lock byte all put together and explained :)
The problem is that many very clever people reverse engineered one or
another aspect of the process but one can hardly find an all-out
explanation.
I dare to claim that some statements one finds on internet made by even
experienced oracle gurus are doubtful to say the least.
Actually, oracle's own metalink is known to provide hmmm.. strange
statements. That happens.
The whole multi versioning is easy to explain at a high level but
implementation is quite tricky.
Why is implementation that important? Because knowing how it works one can
answer some questions right away how fast oracle can perform in particular
situations.
It's less of a black box approach and more of algorithm analysis then.
Thank you in advance,
Laimis N
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 19 2011 - 03:36:24 CDT