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: