Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceMonitoring Tables → MON$DATABASE
Firebird Firebird Prev: MON$CONTEXT_VARIABLESFirebird 2.5 Language ReferenceUp: Monitoring TablesNext: MON$IO_STATS

MON$DATABASE

MON$DATABASE displays the header information from the database the current user is connected to.

Column Name Data Type Description
MON$DATABASE_NAME VARCHAR(255) The file name and full path of the primary database file, or the database alias
MON$PAGE_SIZE SMALLINT Database page size in bytes
MON$ODS_MAJOR SMALLINT Major ODS version, e.g., 11
MON$ODS_MINOR SMALLINT Minor ODS version, e.g., 2
MON$OLDEST_TRANSACTION INTEGER The number of the oldest [interesting] transaction (OIT)
MON$OLDEST_ACTIVE INTEGER The number of the oldest active transaction (OAT)
MON$OLDEST_SNAPSHOT INTEGER The number of the transaction that was active at the moment when the OAT was started - oldest snapshot transaction (OST)
MON$NEXT_TRANSACTION INTEGER The number of the next transaction, as it stood when the monitoring snapshot was taken
MON$PAGE_BUFFERS INTEGER The number of pages allocated in RAM for the database page cache
MON$SQL_DIALECT SMALLINT Database SQL Dialect: 1 or 3
MON$SHUTDOWN_MODE SMALLINT The current shutdown state of the database:
0 - the database is online
1 - multi-user shutdown
2 - single-user shutdown
3 - full shutdown
MON$SWEEP_INTERVAL INTEGER Sweep interval
MON$READ_ONLY SMALLINT Flag indicating whether the database is read-only (value 1) or read-write (value 0)
MON$FORCED_WRITES SMALLINT Indicates whether the write mode of the database is set for synchronous write (forced writes ON, value is 1) or asynchronous write (forced writes OFF, value is 0)
MON$RESERVE_SPACE SMALLINT The flag indicating reserve_space (value 1) or use_all_space (value 0) for filling database pages
MON$CREATION_DATE TIMESTAMP The date and time when the database was created or was last restored
MON$PAGES BIGINT The number of pages allocated for the database on an external device
MON$STAT_ID INTEGER Statistics identifier
MON$BACKUP_STATE SMALLINT Current physical backup (nBackup) state:
0 - normal
1 - stalled
2 - merge

Prev: MON$CONTEXT_VARIABLESFirebird 2.5 Language ReferenceUp: Monitoring TablesNext: MON$IO_STATS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceMonitoring Tables → MON$DATABASE