TMP$RELATIONS
From InterBase
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 |
---|---|---|---|---|
TMP$RELATION_ID
|
SMALLINT
|
Relation identifier | ||
TMP$DATABASE_ID
|
INTEGER
|
Database identifier | ||
TMP$RELATION_NAME
|
CHAR[67]
|
Relation name | ||
TMP$USE_COUNT
|
SMALLINT
|
Statements compiled against relation | ||
TMP$SWEEP_COUNT
|
SMALLINT
|
Database sweep or garbage collector | ||
TMP$SCAN_COUNT
|
INTEGER
|
Sequential scans | ||
TMP$FORMATS
|
SMALLINT
|
Number of relation formats | ||
TMP$POINTER_PAGES
|
INTEGER
|
Number of relation pointer pages | ||
TMP$DATA_PAGES
|
INTEGER
|
Number of relation data pages | ||
TMP$GARBAGE_COLLECT_PAGES
|
INTEGER
|
Number of data pages to garbage collect | ||
TMP$PAGE_READS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page reads all database files |
TMP$PAGE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page writes all database files |
TMP$PAGE_FETCHES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page fetches all database files |
TMP$PAGE_MARKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page marks all database files |
TMP$RECORD_IDX_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records selected by index retrieval |
TMP$RECORD_SEQ_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records selected by sequential scan |
TMP$RECORD_INSERTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records inserted into relation |
TMP$RECORD_UPDATES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records updated in relation |
TMP$RECORD_DELETES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records deleted from relation |
TMP$RECORD_PURGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record purges |
TMP$RECORD_EXPUNGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record expunges |
TMP$RECORD_BACKOUTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record backouts |