TMP$DATABASE

From InterBase
Jump to: navigation, search

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: