I have noticed that our ibserver gets real slow after running for a
number of weeks. I have determined that ibserver is spending a lot of
time managing the "back versions". When I run gstat against the
database, I see that the oldest transaction is real far behind the
next transaction.

Oldest transaction 28570
Oldest active 35571
Oldest snapshot 35571
Next transaction 35573
(Not real data, just to show the point)

Is there any way to find out more about the oldest transaction? I
would like information that may help find what the client was doing
so we can correct the client side problem. Can I retrieve any
statements associated with the trnasaction that may lead to the
tables that were being used?

Thanks
Kevin Heneghan