TMP$RELATIONS

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:

TMP$STATEMENTS