TMP$RELATIONS

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:

• TMP$STATEMENTS