> Hi All,
>
> Last week i asked about sweeping and the oit and oat. Curiously

late friday i was monitoring this GAP value between OIT and OAT which
had been steady and stable with a difference of 1 for most of the
day. Then this GAP started to increase, going to >5000 then up to
18000..I looked at what our systems were doing at this time and
everything was normal activity just like during the day while the GAP
had stayed steady at 1. I continued to monitor and this GAP value
continued to climg to 35000 then to 52000 and ultimately to over
68000. The firebird server cpu showed normal activity and usage
during this difference and there was no impact on our system all be
it Friday after 5pm. Eventually the GAP fell back down to around 700
not longer after. Does that sound normal for a Firebird 1.5 database
server running on Windows 2000 server machine? I assume that although
the GAP value was extremely high, it doesnt mean there is a lot of
unresolved transactions? it just means that there is a transaction
way back down the line that has not been fully dealt with? Also is
sweeping a transaction and does that contribute to this GAP value
while the sweep does its job, then once finished it goes away
reducing the GAP value? Is there anyway to know when a Sweep is
running, can you set up some notification when it occurs?

----

There is no such thing as normal. It is merely reporting what some
information about the database state. It is high because you have a
long running transaction with lots of transactions started in the
interim.

The following article explains how it all fits together:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_expert4

I do not know whether it can be known when a sweep is running,
however it is possible to set the sweep to 0 (disabled) and manually
run it in a scheduled task. This of course works fine when the
transaction load is predictable, but where it is random, it may not
work so well.

Adam