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
Ok thanks for explaining me
-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 19. September 2016 11:52
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Re: AW: Problem querying MON$STATEMENTS
19.09.2016 10:45, 'Gregor Kobler' g...@gksoft.ch [firebird-support] wrote:
> When i monitor the MON$STATEMENTS table for a while, i didn’t see a state 1
> on any statemens.
In single connection workload you won't see any active statements except the
current one.
--
WBR, SD.
or two’s (stalled)
may I make a consideration error
Best Regards
Gregor
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
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
