TMP$DATABASE
From InterBase
Go Up to System Temporary Tables
TMP$DATABASE contains one row for each database you are attached to.
| Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 (no change, if blank) | Data type for >=ODS 16, dialect 3 (no change, if blank) | Description |
|---|---|---|---|---|
TMP$DATABASE_ID
|
INTEGER
|
Database identifier | ||
TMP$DATABASE_PATH
|
VARCHAR[253]
|
Database pathname | ||
TMP$ATTACHMENTS
|
SMALLINT
|
Number of active connections | ||
TMP$STATEMENTS
|
SMALLINT
|
Number of compiled statements | ||
TMP$STATE
|
CHAR[31]
|
FLUSH, SWEEP, RECLAIM | ||
TMP$ALLOCATED_PAGES
|
INTEGER
|
Pages allocated to all database files | ||
TMP$POOLS
|
INTEGER
|
Number of memory pools | ||
TMP$PROCEDURES
|
SMALLINT
|
Number of procedures loaded | ||
TMP$RELATIONS
|
SMALLINT
|
Number of relations loaded | ||
TMP$TRIGGERS
|
SMALLINT
|
Number of triggers loaded | ||
TMP$ACTIVE_THREADS
|
SMALLINT
|
Active threads in database | ||
TMP$SORT_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Sort buffer allocated memory |
TMP$CURRENT_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Current memory allocated database |
TMP$MAXIMUM_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Maximum memory ever allocated |
TMP$PERMANENT_POOL_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Permanent pool memory size |
TMP$CACHE_POOL_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Buffer pool memory size |
TMP$TRANSACTIONS
|
SMALLINT
|
Number of active transactions | ||
TMP$TRANSACTION_COMMITS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of transaction commits |
TMP$TRANSACTION_ROLLBACKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of transaction rollbacks |
TMP$TRANSACTION_PREPARES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of transaction prepares |
TMP$TRANSACTION_DEADLOCKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of transaction deadlocks |
TMP$TRANSACTION_CONFLICTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of transaction update conflicts |
TMP$TRANSACTION_WAITS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of transaction wait for |
TMP$NEXT_TRANSACTION
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Next transaction number |
TMP$OLDEST_INTERESTING
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Oldest interesting transaction |
TMP$OLDEST_ACTIVE
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Oldest active transaction |
TMP$OLDEST_SNAPSHOT
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Oldest snapshot transaction |
TMP$CACHE_BUFFERS
|
INTEGER
|
Number of cache buffers | ||
TMP$CACHE_PRECEDENCE
|
INTEGER
|
Nodes in cache precedence graph | ||
TMP$CACHE_LATCH_WAITS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Buffer latch waits |
TMP$CACHE_FREE_WAITS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of waits for a free buffer |
TMP$CACHE_FREE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Number of writes to free buffers |
TMP$SWEEP_INTERVAL
|
INTEGER
|
Sweep trigger interval | ||
TMP$SWEEP_ACTIVE
|
CHAR[1]
|
Y (active) N (not-active) | ||
TMP$SWEEP_RELATION
|
CHAR[67]
|
Relation currently being swept | ||
TMP$SWEEP_RECORDS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records swept in above relation |
TMP$PAGE_READS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page reads all database files |
TMP$PAGE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page writes all database files |
TMP$PAGE_FETCHES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page fetches all database files |
TMP$PAGE_MARKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page marks all database files |
TMP$RECORD_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records selected from database |
TMP$RECORD_INSERTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records inserted into database |
TMP$RECORD_UPDATES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records updated to database |
TMP$RECORD_DELETES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records deleted from database |
TMP$RECORD_PURGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Garbage collect record purges |
TMP$RECORD_EXPUNGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Garbage collect record expunges |
TMP$RECORD_BACKOUTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Garbage collect record backouts |