Arn wrote:

>
> I have some recursive SP.
> They don't move the OAT, so after some minutes the gap from OAT
> and new transaction is over 500 or 600.

That's probably not the end of the world. A gap of 1000 or more
is worth looking at - a gap over 10,000 is likely to be a problem.
If you're running a lot of transactions and some of them perform
complex, time-consuming tasks, you'll see growth in the gap between
the oldest active transaction and the next..

>
> As pointed out from Martijn and Adam the slowinness of the app depend
> heavly from this gap.
>
> I have set SweepInterval to 50, but no results.
>

As long as you have an old transaction running, the OAT won't move.
All you can do is commit as often as is reasonable.


Regards,

Ann