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) correctly.
The ID #192 shows the statements fort he second open table «HORNCODE», but there are the state 0 (idle).
Why shows the #228 a state 1 and the #192 a zero??
When i monitor the MON$STATEMENTS table for a while, i didn't see a state 1 on any statemens. I see just zero's 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 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
[Non-text portions of this message have been removed]
Posted by: "Gregor Kobler" <gk@gksoft.ch>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (8) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment