Re: Fwd: Snapshot too old from READ-ONLY table (data pump export)

http://arup.blogspot.com/2011/01/more-on-interested-transaction-lists.html

Ron

Quoting Laimutis.Nedzinskas_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-l
>
>
>
>

  http://www.linkedin.com/in/ronchennells

--
http://www.freelists.org/webpage/oracle-l