AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support]
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

AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support]
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

Re: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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.

AW: [firebird-support] Re: AW: Problem querying MON$STATEMENTS table

2016-09-19 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support]
Hello Dimitry May i didn’t understand something not correct, but look below In that excaple, i have 2 open tables «MON$STATEMENTS» and «HORNCODE» The ID #228 are the Statement for the table «MON$STATEMENTS» and shows a transaction id and a timestamp the State are 1 (active)