""Nick Upson"" <uebridger@...> wrote in message
news:F1060UzU2ZcF9KdzDB5000153a2@......

> why, when there are no active connections, is there a difference
> between the oldest and next transactions.
>
>
> Oldest transaction 682

Oldest uncommited transactions (limbo, rolled back, active)

> Oldest active 683

Oldest active transactions (active only)

> Next transaction 716

self explanatory

As the sweep is the only thing that will get rid of rolled back
transactions, then there is likely to be a difference.

Also I believe that it is the start transaction that clears up the TIP
(Transaction information page?).

Plus for you to get info from the TIP, I'm guessing that the tool that gets
ut starts its own transaction.

My 2c.

JAC.