AGENT_ID |
BIGINT |
agent_id
- Application handle (agent ID) |
AGENTS_TOP |
BIGINT |
agents_top
- Number of agents created |
APPL_ID |
VARCHAR(64) |
appl_id
- Application ID |
BLOCKING_CURSOR |
SMALLINT |
blocking_cursor
- Blocking cursor |
CONSISTENCY_TOKEN |
CHARACTER |
consistency_token
- Package consistency token |
CREATOR |
VARCHAR(128) |
creator
- Application creator |
CURSOR_NAME |
VARCHAR(18) |
cursor_name
- Cursor name |
EVMON_FLUSHES |
BIGINT |
evmon_flushes
- Number of event monitor flushes |
FETCH_COUNT |
BIGINT |
fetch_count
- Number of successful fetches |
INT_ROWS_DELETED |
BIGINT |
int_rows_deleted
- Internal rows deleted |
INT_ROWS_INSERTED |
BIGINT |
int_rows_inserted
- Internal rows inserted |
INT_ROWS_UPDATED |
BIGINT |
int_rows_updated
- Internal rows updated |
PACKAGE_NAME |
VARCHAR(128) |
package_name
- Package name |
PACKAGE_VERSION_ID |
VARCHAR(64) |
package_version_id
- Package version |
PARTIAL_RECORD |
SMALLINT |
partial_record
- Partial record |
POOL_DATA_L_READS |
BIGINT |
pool_data_l_reads
- Buffer pool data logical reads |
POOL_DATA_P_READS |
BIGINT |
pool_data_p_reads
- Buffer pool data physical reads |
POOL_INDEX_L_READS |
BIGINT |
pool_index_l_reads
- Buffer pool index logical reads |
POOL_INDEX_P_READS |
BIGINT |
pool_index_p_reads
- Buffer pool index physical reads |
POOL_TEMP_DATA_L_READS |
BIGINT |
pool_temp_data_l_reads
- Buffer pool temporary data logical reads |
POOL_TEMP_DATA_P_READS |
BIGINT |
pool_temp_data_p_reads
- Buffer pool temporary data physical reads |
POOL_TEMP_INDEX_L_READS |
BIGINT |
pool_temp_index_l_reads
- Buffer pool temporary index logical reads |
POOL_TEMP_INDEX_P_READS |
BIGINT |
pool_temp_index_p_reads
- Buffer pool temporary index physical reads |
POOL_TEMP_XDA_L_READS |
BIGINT |
pool_temp_xda_l_reads
- Buffer pool temporary XDA data logical reads |
POOL_TEMP_XDA_P_READS |
BIGINT |
pool_temp_xda_p_reads
- Buffer pool temporary XDA data physical reads |
POOL_XDA_L_READS |
BIGINT |
pool_xda_l_reads
- Buffer pool XDA data logical reads |
POOL_XDA_P_READS |
BIGINT |
pool_xda_p_reads
- Buffer pool XDA data physical reads |
ROWS_READ |
BIGINT |
rows_read
- Rows read |
ROWS_WRITTEN |
BIGINT |
rows_written
- Rows written |
SECTION_NUMBER |
BIGINT |
section_number
- Section number |
SEQUENCE_NO |
CHARACTER |
sequence_no
- Sequence number |
SORT_OVERFLOWS |
BIGINT |
sort_overflows
- Sort overflows |
SQL_REQ_ID |
BIGINT |
sql_req_id
- Request identifier for SQL statement |
SQLCABC |
INTEGER |
See SQLCA (SQL communications area). |
SQLCAID |
CHARACTER |
See SQLCA (SQL communications area). |
SQLCODE |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRD1 |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRD2 |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRD3 |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRD4 |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRD5 |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRD6 |
INTEGER |
See SQLCA (SQL communications area). |
SQLERRM |
VARCHAR(72) |
See SQLCA (SQL communications area). |
SQLERRP |
CHARACTER |
See SQLCA (SQL communications area). |
SQLSTATE |
CHARACTER |
See SQLCA (SQL communications area). |
SQLWARN |
CHARACTER |
See SQLCA (SQL communications area). |
START_TIME |
TIMESTAMP |
start_time
- Event start time |
STATS_FABRICATE_TIME |
BIGINT |
stats_fabricate_time
- Total time spent on statistics fabrication activities |
STMT_OPERATION |
BIGINT |
|
STMT_TYPE |
BIGINT |
stmt_type
- Statement type |
STOP_TIME |
TIMESTAMP |
stop_time
- Event stop time |
SYNC_RUNSTATS_TIME |
BIGINT |
sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element |
SYSTEM_CPU_TIME |
BIGINT |
system_cpu_time
- System CPU time |
TOTAL_SORT_TIME |
BIGINT |
total_sort_time
- Total sort time |
TOTAL_SORTS |
BIGINT |
total_sorts
- Total sorts |
USER_CPU_TIME |
BIGINT |
user_cpu_time
- User CPU time |
STMT_TEXT |
CLOB (2097152) |
stmt_text
- SQL statement text |