TMP$TRANSACTIONS
From InterBase
Go Up to System Temporary Tables
The TMP$TRANSACTIONS table contains one row for each transaction that is active or in limbo.
| Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 | Data type for >=ODS 16, dialect 3 | Description |
|---|---|---|---|---|
TMP$TRANSACTION_ID
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Transaction number |
TMP$ATTACHMENT_ID
|
INTEGER
|
Connection identifier | ||
TMP$POOL_ID
|
INTEGER
|
|||
TMP$POOL_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
|
TMP$TIMESTAMP
|
TIMESTAMP
|
Start time of connection | ||
TMP$SNAPSHOT
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Snapshot transaction number |
TMP$QUANTUM
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Units of execution |
TMP$SAVEPOINTS
|
INTEGER
|
savepoint number of records | ||
TMP$READONLY
|
CHAR[1]
|
Transaction is read only | ||
TMP$WRITE
|
CHAR[1]
|
Transaction has written data | ||
TMP$NOWAIT
|
CHAR[1]
|
Transaction is no wait | ||
TMP$COMMIT_RETAINING
|
CHAR[1]
|
Commit retaining performed | ||
TMP$STATE
|
CHAR[31]
|
ACTIVE,LIMBO,COMMITTING,PRECOMMITTED
Allowed Update actions: | ||
TMP$PRIORITY
|
CHAR
|
Reserved | ||
TMP$TYPE
|
CHAR[31]
|
SNAPSHOT,READ_COMMITTED
| ||
TMP$PAGE_READS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page reads all database files |
TMP$PAGE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page writes all database files |
TMP$PAGE_FETCHES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page fetches all database files |
TMP$PAGE_MARKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page marks all database files |
TMP$RECORD_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records selected by transaction |
TMP$RECORD_INSERTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records inserted by transaction |
TMP$RECORD_UPDATES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records updated by transaction |
TMP$RECORD_DELETES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records deleted by transaction |
TMP$RECORD_PURGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record purges |
TMP$RECORD_EXPUNGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record expunges |
TMP$RECORD_BACKOUTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record backouts |