TMP$PROCEDURES

Go Up to System Temporary Tables

The TMP$PROCEDURES table contains one row for each procedure executed since the current connection began.

TMP$PROCEDURES

Column name	Datatype for <=ODS 15	Datatype for >=ODS 16, dialect 1	Datatype for >=ODS 16, dialect 3	Description
TMP$PROCEDURE_ID	INTEGER			Procedure identifier
TMP$DATABASE_ID	INTEGER			Database identifier
TMP$PROCEDURE_NAME	CHAR[67]			Procedure name
TMP$POOL_ID	INTEGER			Pool identifier
TMP$POOL_MEMORY	INTEGER			Pool memory size
TMP$CLONE	SMALLINT			Cloned instance number
TMP$TIMESTAMP	TIMESTAMP			Start time of procedure
TMP$USE_COUNT	SMALLINT			Statements compiled with procedure
TMP$QUANTUM	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Units of execution
TMP$INVOCATIONS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Number of calls to procedure
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 procedure
TMP$RECORD_INSERTS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records inserted by procedure
TMP$RECORD_UPDATES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records updated by procedure
TMP$RECORD_DELETES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records deleted by procedure
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