Bogusław Brandys wrote:

>
> Database header page information:
> Oldest transaction 270
> Oldest active 255
> Oldest snapshot 255
> Next transaction 271

>
>
> I was surprized by the fact that Oldest active is not exactly the same
> as Oldest transaction. What that means ?
>

I think it means that you haven't had any transaction roll back. At the
time that the header snapshot was taken, transaction 270 was active, and
when it started transaction 255 was active. Transactions 255-269 have
subsequently committed.

Regards,


Ann