TMP$DATABASE

From InterBase

Go Up to System Temporary Tables


TMP$DATABASE contains one row for each database you are attached to.

TMP$DATABASE
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

Advance To: