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
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
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