TMP$STATEMENTS
Go Up to System Temporary Tables
The TMP$STATEMENTS
table contains one row for each statement currently executing for any current connection.
Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 | Data type for >=ODS 16, dialect 3 | Description |
---|---|---|---|---|
|
|
Statement identifier | ||
|
|
Connection identifier | ||
|
|
DOUBLE PRECISION |
|
Transaction number |
|
|
SQL string | ||
|
|
Pool identifier | ||
|
|
DOUBLE PRECISION |
|
Pool memory size |
|
|
Cloned instance number | ||
|
|
Start time of statement | ||
|
|
DOUBLE PRECISION |
|
Units of execution |
|
|
Number of calls to statement | ||
|
|
Current State: Allowed Update actions: | ||
|
|
Reserved | ||
|
|
DOUBLE PRECISION |
|
Page reads all database files |
|
|
DOUBLE PRECISION |
|
Page writes all database files |
|
|
DOUBLE PRECISION |
|
Page fetches all database files |
|
|
DOUBLE PRECISION |
|
Page marks all database files |
|
|
DOUBLE PRECISION |
|
Records selected by statement |
|
|
DOUBLE PRECISION |
|
Records inserted by statement |
|
|
DOUBLE PRECISION |
|
Records updated by statement |
|
|
DOUBLE PRECISION |
|
Records deleted by statement |
|
|
DOUBLE PRECISION |
|
Garbage collect record purges |
|
|
DOUBLE PRECISION |
|
Garbage collect record expunges |
|
|
DOUBLE PRECISION |
|
Garbage collect record backouts |