E.10 MON$TRANSACTIONS

MON$TRANSACTIONS reports started transactions.

Column Name Data Type Description
MON$TRANSACTION_ID BIGINT Transaction identifier (number)
MON$ATTACHMENT_ID BIGINT Connection identifier
MON$STATE SMALLINT Transaction state: 0 - idle 1 - active
MON$TIMESTAMP TIMESTAMP The date and time when the transaction was started
MON$TOP_TRANSACTION BIGINT Top-level transaction identifier (number)
MON$OLDEST_TRANSACTION BIGINT Transaction ID of the oldest [interesting] transaction (OIT)
MON$OLDEST_ACTIVE BIGINT Transaction ID of the oldest active transaction (OAT)
MON$ISOLATION_MODE SMALLINT Isolation mode (level): 0 - consistency (snapshot table stability) 1 - concurrency (snapshot) 2 - read committed record version 3 - read committed no record version 4 - read committed read consistency
MON$LOCK_TIMEOUT SMALLINT Lock timeout: -1 - wait forever 0 - no waiting 1 or greater - lock timeout in seconds
MON$READ_ONLY SMALLINT Flag indicating whether the transaction is read-only (value 1) or read-write (value 0)
MON$AUTO_COMMIT SMALLINT Flag indicating whether automatic commit is used for the transaction (value 1) or not (value 0)
MON$AUTO_UNDO SMALLINT Flag indicating whether the logging mechanism automatic undo is used for the transaction (value 1) or not (value 0)
MON$STAT_ID INTEGER Statistics identifier

Getting all connections that started Read Write transactions with isolation level above Read Commited

1. SELECT DISTINCT a. *
2. FROM mon$attachments a
3. JOIN mon$transactions t ON a.mon$attachment_id = t.mon$attachment_id
4. WHERE NOT (t.mon$read_only = 1 AND t.mon$isolation_mode >= 2)