I am working on a Debian Linux, Etch, AMD 64 bits.
FB SS 2.1.1.

After all users have closed all systems (22:00), gstat says that my oldest active transaction (oat) is 191 and mon$ tables say that same oat is 21226. gstat reported as 191 during the whole day, but I could not find the command which generated this transaction.

1. Which oat number is correct?
2. I can not find transaction 191 via selecting mon$ tables. What select should I use for discovering the command (DDL, DML, DCL, TCL or DQL) which generated my last real oat (191 or 21226)?
3. FB 2.1.1 transactions have "time out"?


Here my statistic information of gstat and mon$ tables:

-------------------------
# date ; /opt/firebird/bin/gstat -h names.fdb
Sat Nov 8 22:41:22 BRST 2008

Database "names.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 21232
Page size 16384
ODS version 11.1
Oldest transaction 190
Oldest active 191
Oldest snapshot 191
Next transaction 21223
Bumped transaction 1
Sequence number 0
Next attachment ID 34
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 8, 2008 3:23:55
Attributes force write, no reserve

Variable header data:
Sweep interval: 0
*END*



08.Nov.2008 22:43
MON$DATABASE_NAME = /srv/company/data/names.fdb
MON$PAGE_SIZE = 16384
MON$ODS_MAJOR = 11
MON$ODS_MINOR = 1
MON$OLDEST_TRANSACTION = 21225
MON$OLDEST_ACTIVE = 21226
MON$OLDEST_SNAPSHOT = 21226
MON$NEXT_TRANSACTION = 21227
MON$PAGE_BUFFERS = 2048
MON$SQL_DIALECT = 3
MON$SHUTDOWN_MODE = 0
MON$SWEEP_INTERVAL = 0
MON$READ_ONLY = 0
MON$FORCED_WRITES = 1
MON$RESERVE_SPACE = 0
MON$CREATION_DATE = '08.11.2008, 03:23:55.165'
MON$PAGES = 199886
MON$STAT_ID = 1
MON$BACKUP_STATE = 0
-------------------------

Thanks.



[Non-text portions of this message have been removed]