--- In firebird-support@yahoogroups.com, "Michael Vilhelmsen" wrote: > > Ah - you are right :) > Its the amount of start/commit I was referring to. My bad. > > Statistics are as of now: > > Database "E:\DB\OCCeasyPos.Fdb" > Database header page information: > Flags 0 > Checksum 12345 > Generation 55467812 > Page size 4096 > ODS version 11.1 > Oldest transaction 54691256 > Oldest active 55360946 > Oldest snapshot 55360946 > Next transaction 55467714
Next - OIT = 776458, i.e. every snapshot (concurrency) transaction requires ~192KB for private TIP snapshot. Also, at transaction start, it should read 48 TIP pages to build that private TIP snapshot. You should sweep database fromt time to time to "unstuck" OIT. Look also at Next - OAT = 106768, it show that there are long running transaction(s) present. Look at MON$TRANSACTION for tx 55360946 to see what is it and fix application which was started it. Good luck, Vlad
