"Ann W. Harrison" <aharrison@...> wrote:

>
> Oracle provides limited snapshots to support repeatable read without
> maintaining read locks on records and access paths. So, Oracle has
> multi-generational records - though I think I remember that they create
> shadow pages rather than shadow records in the same page space as the
> primary record.

Oracle has multi-generational blocks (pages) instead of multi-generational
records. Their records are not a subject of the versioning. But MSSQL 2005
has the same (or at least very similar) MGA mechanism as Firebird.


Dmitry