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.

TMP$RELATIONS
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

(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_IDX_SELECTS INTEGER DOUBLE PRECISION NUMERIC

(18,0)

Records selected by index retrieval
TMP$RECORD_SEQ_SELECTS INTEGER DOUBLE PRECISION NUMERIC

(18,0)

Records selected by sequential scan
TMP$RECORD_INSERTS INTEGER DOUBLE PRECISION NUMERIC

(18,0)

Records inserted into relation
TMP$RECORD_UPDATES INTEGER DOUBLE PRECISION NUMERIC

(18,0)

Records updated in relation
TMP$RECORD_DELETES INTEGER DOUBLE PRECISION NUMERIC

(18,0)

Records deleted from relation
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: