[Firebird-devel] MON$STATEMENTS.MON$STATE = 2?

2012-02-03 Thread Thomas Steinmaurer
Hello, what's the meaning of 2 for MON$STATEMENTS.MON$STATE? I don't see that anywhere documented. Thanks, Thomas -- Try before you buy = See our experts in action! The most comprehensive online learning library for

Re: [Firebird-devel] MON$STATEMENTS.MON$STATE = 2?

2012-02-03 Thread Dmitry Yemanov
03.02.2012 14:10, Thomas Steinmaurer wrote: what's the meaning of 2 for MON$STATEMENTS.MON$STATE? STALLED. I.e. an interval between client fetches from the open cursor. Priorly this state was reported as ACTIVE because the query is alive and running but the CPU time is not spent by the engine

Re: [Firebird-devel] MON$STATEMENTS.MON$STATE = 2?

2012-02-03 Thread Thomas Steinmaurer
what's the meaning of 2 for MON$STATEMENTS.MON$STATE? STALLED. I.e. an interval between client fetches from the open cursor. Priorly this state was reported as ACTIVE because the query is alive and running but the CPU time is not spent by the engine in this interval. Thanks! Thomas