| 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 |
|
