Hi,

> 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.

I fail to see how calling a recursive SP will add to your transaction
counter?

Make sure your transactions are committed always.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

>
> I have set SweepInterval to 50, but no results.
>
> Somebody can help here?
>
> TIA
> Arn
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>