TMP$STATEMENTS

Go Up to System Temporary Tables

The TMP$STATEMENTS table contains one row for each statement currently executing for any current connection.

TMP$STATEMENTS

Column name	Data type for <=ODS 15	Data type for >=ODS 16, dialect 1	Data type for >=ODS 16, dialect 3	Description
TMP$STATEMENT_ID	INTEGER			Statement identifier
TMP$ATTACHMENT_ID	INTEGER			Connection identifier
TMP$TRANSACTION_ID	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Transaction number
TMP$SQL	VARCHAR[4094]			SQL string
TMP$POOL_ID	INTEGER			Pool identifier
TMP$POOL_MEMORY	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Pool memory size
TMP$CLONE	SMALLINT			Cloned instance number
TMP$TIMESTAMP	TIMESTAMP			Start time of statement
TMP$QUANTUM	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Units of execution
TMP$INVOCATIONS	INTEGER			Number of calls to statement
TMP$STATE	CHAR[31]			Current State: ACTIVE, INACTIVE, STALLED, CANCELLED Allowed Update actions: CANCEL
TMP$PRIORITY	CHAR[31]			Reserved
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_SELECTS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records selected by statement
TMP$RECORD_INSERTS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records inserted by statement
TMP$RECORD_UPDATES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records updated by statement
TMP$RECORD_DELETES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records deleted by statement
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$TRANSACTIONS