| Subject | Re: AW: Problem querying MON$STATEMENTS table |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2016-09-17T10:33:19Z |
16.09.2016 09:02, 'Gregor Kobler'wrote:
they're NULL for idle ones. You've said that MON$STATE = 0, so your
statements are idle, not active.
Dmitry
>Transaction ID and timestamp are reported only for active statements,
> 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!
they're NULL for idle ones. You've said that MON$STATE = 0, so your
statements are idle, not active.
Dmitry