Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceMonitoring Tables → MON$TRANSACTIONS
Firebird Firebird Prev: MON$STATEMENTSFirebird 2.5 Language ReferenceUp: Monitoring TablesNext: Character Sets and Collation Sequences

MON$TRANSACTIONS

MON$TRANSACTIONS reports started transactions.

Column Name Data Type Description
MON$TRANSACTION_ID INTEGER Transaction identifier (number)
MON$ATTACHMENT_ID INTEGER 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 INTEGER Top-level transaction identifier (number)
MON$OLDEST_TRANSACTION INTEGER Transaction ID of the oldest [interesting] transaction (OIT)
MON$OLDEST_ACTIVE INTEGER 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
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

Prev: MON$STATEMENTSFirebird 2.5 Language ReferenceUp: Monitoring TablesNext: Character Sets and Collation Sequences
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceMonitoring Tables → MON$TRANSACTIONS