STAT_ID |
Statement Identifier |
CHAR |
3 |
0 |
|
SQL_STID
|
|
EXECUTIONS |
Total number of executions of identical statements |
CHAR |
10 |
0 |
|
SQLTTOTALE
|
|
IDENTICAL |
Percentage of statements that are identical |
CHAR |
9 |
0 |
|
SQLTSTATID
|
|
DURATION |
Total statement execution time |
CHAR |
12 |
0 |
|
SQLTSDURA
|
|
TIMEPEREXE |
Average time per execution |
CHAR |
10 |
0 |
|
SQLTTPEXEC
|
|
ROWS |
Total number of records processed |
CHAR |
10 |
0 |
|
SQLTROWS
|
|
ROWSPEREXE |
Average number of records executed per execution |
CHAR |
10 |
0 |
|
SQLTRPEXEC
|
|
AVGTPERROW |
Average processing time per record |
CHAR |
10 |
0 |
|
SQLTAVGTPR
|
|
MINTPERROW |
Minimum Processing Time per Record |
CHAR |
10 |
0 |
|
SQLTMINTPR
|
|
BUFFERTYPE |
Table buffer type |
CHAR |
5 |
0 |
|
SQLTBUFTYP
|
|
TABLEN |
Table row length |
CHAR |
6 |
0 |
|
SQLTTLENSI
|
|
TABCLASS |
Table category |
CHAR |
8 |
0 |
|
SQLTTABCLA
|
|
TABLE_L |
Object used in trace statement |
CHAR |
30 |
0 |
|
SQLTTABLE
|
|
STATEMENT |
Short SQL statement |
CHAR |
110 |
0 |
|
SQLTSTATM
|
|