TMP$DATABASE

Go Up to System Temporary Tables

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

TMP$DATABASE

Column name	Datatype for <=ODS 15	Datatype for >=ODS 16, dialect 1	Datatype for >=ODS 16, dialect 3	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