>From: "Jason Chapman (JAC2)" <jason@...>
>""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.

so if a rollback is done the oldest transaction is stuck until
a sweep is done???

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

I started and stopped a transaction before getting these figures

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

I used gstat, if it does have it's own transaction (which I doubt as
immediately after a sweep the figures are within 2 or 3 of each other)
the figures would now be close together as you say that it's the start
transaction the clears up the TIP.


_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx