MON$TRANSACTIONS

System TablesSecurity tables

`MON$TRANSACTIONS`

MON$TRANSACTIONS reports started transactions.

Column Name Data Type Description

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 WITH TIME ZONE`	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

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 WITH TIME ZONE

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

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

`MON$COMPILED_STATEMENTS`

Virtual table listing compiled statements.

Column Name Data Type Description

Column Name	Data Type	Description
`MON$COMPILED_STATEMENT_ID`	`BIGINT`	Compiled statement id
`MON$SQL_TEXT`	`BLOB TEXT`	Statement text
`MON$EXPLAINED_PLAN`	`BLOB TEXT`	Explained query plan
`MON$OBJECT_NAME`	`CHAR(63)`	PSQL object name
`MON$OBJECT_TYPE`	`SMALLINT`	PSQL object type: `2` - trigger `5` - stored procedure `15` - stored function
`MON$PACKAGE_NAME`	`CHAR(63)`	PSQL object package name
`MON$STAT_ID`	`INTEGER`	Statistics identifier

MON$COMPILED_STATEMENT_ID

BIGINT

Compiled statement id

MON$SQL_TEXT

BLOB TEXT

Statement text

MON$EXPLAINED_PLAN

BLOB TEXT

Explained query plan

MON$OBJECT_NAME

CHAR(63)

PSQL object name

MON$OBJECT_TYPE

SMALLINT

PSQL object type:

2 - trigger
5 - stored procedure
15 - stored function

MON$PACKAGE_NAME

CHAR(63)

PSQL object package name

MON$STAT_ID

INTEGER

Statistics identifier