Hi,

You can display running transactions with
SELECT * FROM MON$TRANSACTIONS

Gabor


Olaf Kluge írta:

>
> Hi,
>
> the statistics were created were the application is running, but after
> restart the server. In this time the statistics:
>
> oldest: 23731516
> oldest act. 23731517
> oldest sn. 23731517
> next trans. 23731518
>
> next attachm. 2181
>
> But the firebird process used 477 memory at the moment, increasing.
>
> What says me the attachment-information? The User reads 11,2 MB and writes 1
> GB. Three statements are open and sometimes one read commited transaction.
> But how the statistics said, the transactions were closed.
>
> Thanks for help.