Subject AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table
Author Gregor Kobler

Follow the link to the missing picture!

http://screencast.com/t/EKQeG7QRqBS

 

 

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Samstag, 17. September 2016 12:33
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

 

 

16.09.2016 09:02, 'Gregor Kobler'wrote:

>
> When you querying the MON$STATEMENTS table, the active statements are
> not shows a transaction-id and not a timestamp, These columns are allwas
> Zero / NULL!

Transaction ID and timestamp are reported only for active statements,
they're NULL for idle ones. You've said that MON$STATE = 0, so your
statements are idle, not active.

Dmitry