TMP$DATABASE
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 |
|---|---|---|---|---|
|
|
|
Database identifier | ||
|
|
|
Database pathname | ||
|
|
|
Number of active connections | ||
|
|
|
Number of compiled statements | ||
|
|
|
FLUSH, SWEEP, RECLAIM | ||
|
|
|
Pages allocated to all database files | ||
|
|
|
Number of memory pools | ||
|
|
|
Number of procedures loaded | ||
|
|
|
Number of relations loaded | ||
|
|
|
Number of triggers loaded | ||
|
|
|
Active threads in database | ||
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Sort buffer allocated memory |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Current memory allocated database |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Maximum memory ever allocated |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Permanent pool memory size |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Buffer pool memory size |
|
|
|
Number of active transactions | ||
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of transaction commits |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of transaction rollbacks |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of transaction prepares |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of transaction deadlocks |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of transaction update conflicts |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of transaction wait for |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Next transaction number |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Oldest interesting transaction |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Oldest active transaction |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Oldest snapshot transaction |
|
|
|
|
|
Number of cache buffers |
|
|
|
Nodes in cache precedence graph | ||
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Buffer latch waits |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of waits for a free buffer |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Number of writes to free buffers |
|
|
|
Sweep trigger interval | ||
|
|
|
Y (active) N (not-active) | ||
|
|
|
Relation currently being swept | ||
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Records swept in above relation |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Page reads all database files |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Page writes all database files |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Page fetches all database files |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Page marks all database files |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Records selected from database |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Records inserted into database |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Records updated to database |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Records deleted from database |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Garbage collect record purges |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Garbage collect record expunges |
|
|
|
DOUBLE PRECISION |
NUMERIC (18, 0) |
Garbage collect record backouts |