TMP$PROCEDURES

From InterBase
Jump to: navigation, search

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 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

(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

Advance To: