TMP$RELATIONS
Go Up to System Temporary Tables
The TMP$RELATIONS
table contains one row for each relation referenced since the current connection began.
Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 | Data type for >=ODS 16, dialect 3 | Description |
---|---|---|---|---|
|
|
Relation identifier | ||
|
|
Database identifier | ||
|
|
Relation name | ||
|
|
Statements compiled against relation | ||
|
|
|
|
Database sweep or garbage collector |
|
|
Sequential scans | ||
|
|
Number of relation formats | ||
|
|
Number of relation pointer pages | ||
|
|
Number of relation data pages | ||
|
|
|
|
Number of data pages to garbage collect |
|
|
DOUBLE PRECISION |
|
Page reads all database files |
|
|
DOUBLE PRECISION |
|
Page writes all database files |
|
|
DOUBLE PRECISION |
|
Page fetches all database files |
|
|
DOUBLE PRECISION |
|
Page marks all database files |
|
|
DOUBLE PRECISION |
|
Records selected by index retrieval |
|
|
DOUBLE PRECISION |
|
Records selected by sequential scan |
|
|
DOUBLE PRECISION |
|
Records inserted into relation |
|
|
DOUBLE PRECISION |
|
Records updated in relation |
|
|
DOUBLE PRECISION |
|
Records deleted from relation |
|
|
DOUBLE PRECISION |
|
Garbage collect record purges |
|
|
DOUBLE PRECISION |
|
Garbage collect record expunges |
|
|
DOUBLE PRECISION |
|
Garbage collect record backouts |