> 1. Why restart the server can bring down the OAT/Next Transaction gap
> without doing backup/restore or sweep ?.

If applications are holding it open, perhaps some particular
window in an application.

> 2 Why FB cannot bring down the gap by itself under heavy load ?. (The
> problem do not occur on light-load days)

Because it is doing it's job and keeping the view asked for
on one open transaction?

> 3 We set sweep interval = 20,000. Would it help if we set sweep interval to
> 3,000? Will the sweep process clear the OAT/Next Transaction gap?.

Set it to 0 and run sweep at night when it's quiet. Then it
WONT happen just as you get busy <g>

> 4 The Application use IBO with AutoCommit transaction. If the explicit
> transaction is used it is always end with Commit or rollback. Can Rollback
> contribute to this problem?

Switching to IBO cleared all my BDE related transaction
problems, so it's unusual for something to stay open. I
would still suggest that may be the problem.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services