TMP$PROCEDURES
From InterBase
Go Up to System Temporary Tables
The TMP$PROCEDURES table contains one row for each procedure executed since the current connection began.
| Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 | Data type 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
|
Units of execution |
TMP$INVOCATIONS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Number of calls to procedure |
TMP$PAGE_READS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page reads all database files |
TMP$PAGE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page writes all database files |
TMP$PAGE_FETCHES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page fetches all database files |
TMP$PAGE_MARKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page marks all database files |
TMP$RECORD_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records selected by procedure |
TMP$RECORD_INSERTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records inserted by procedure |
TMP$RECORD_UPDATES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records updated by procedure |
TMP$RECORD_DELETES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records deleted by procedure |
TMP$RECORD_PURGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record purges |
TMP$RECORD_EXPUNGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record expunges |
TMP$RECORD_BACKOUTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record backouts |