Information written to tables for a database event monitor

Information written by an database event monitor when the WRITE TO TABLE option is specified.

When you choose WRITE TO TABLE as the ouput type for the database event monitor, by default, three tables are produced, each containing monitor elements from one or more logical data groups:
Table 1. Tables produced by DATABASE write-to-table event monitors. The table name is derived by concatenating the name of the logical data group used to populate the table with the name given to the event monitor (as represented by evmon-name in the table names shown in the following table) in the CREATE EVENT MONITOR statement.
Default table name Logical data groups reported
DB_evmon-name event_db
DBMEMUSE_evmon-name event_dbmemuse
CONTROL_evmon-name The CONTROL logical group consists of selected elements from one or more of the event_dbheader, event_start and event_overflow logical data groups.
To restrict the output of the event monitor to specific tables, specify the names of the logical groups for which you want tables produced in the CREATE EVENT MONITOR or ALTER EVENT MONITOR statements. Refer to the reference topics for those statements for details.

For information about the output returned when the event monitor writes to a file or named pipe, see Event monitor self-describing data stream.

Tables produced

Table 2. Information returned for a database event monitor: Default table name: DB_evmon-name
Column name Data type Description
APPL_SECTION_INSERTS BIGINT appl_section_inserts - Section inserts
APPL_SECTION_LOOKUPS BIGINT appl_section_lookups - Section lookups
ASYNC_RUNSTATS BIGINT async_runstats - Total number of asynchronous RUNSTATS requests
BINDS_PRECOMPILES BIGINT binds_precompiles - Binds/precompiles attempted
BLOCKS_PENDING_CLEANUP BIGINT blocks_pending_cleanup - Pending cleanup rolled-out blocks
CAT_CACHE_HEAP_FULL BIGINT cat_cache_heap_full - Catalog cache heap full
CAT_CACHE_INSERTS BIGINT cat_cache_inserts - Catalog cache inserts
CAT_CACHE_LOOKUPS BIGINT cat_cache_lookups - Catalog cache lookups
CAT_CACHE_OVERFLOWS BIGINT cat_cache_overflows - Catalog cache overflows
CAT_CACHE_SIZE_TOP BIGINT cat_cache_size_top - Catalog cache high watermark
CATALOG_NODE BIGINT catalog_node - Catalog node number
CATALOG_NODE_NAME VARCHAR(32) catalog_node_name - Catalog node network name
COMMIT_SQL_STMTS BIGINT commit_sql_stmts - Commit statements attempted
CONNECTIONS_TOP BIGINT connections_top - Maximum number of concurrent connections
DB_HEAP_TOP BIGINT db_heap_top - Maximum database heap allocated
DDL_SQL_STMTS BIGINT ddl_sql_stmts - Data definition language (DDL) SQL statements
DEADLOCKS BIGINT deadlocks - Deadlocks detected
DIRECT_READ_REQS BIGINT direct_read_reqs - Direct read requests
DIRECT_READ_TIME BIGINT direct_read_time - Direct read time
DIRECT_READS BIGINT direct_reads - Direct reads from database
DIRECT_WRITE_REQS BIGINT direct_write_reqs - Direct write requests
DIRECT_WRITE_TIME BIGINT direct_write_time - Direct write time
DIRECT_WRITES BIGINT direct_writes - Direct writes to database
DISCONN_TIME TIMESTAMP disconn_time - Database deactivation timestamp
DYNAMIC_SQL_STMTS BIGINT dynamic_sql_stmts - Dynamic SQL statements attempted
ELAPSED_EXEC_TIME BIGINT elapsed_exec_time - Statement execution elapsed time
EVMON_ACTIVATES BIGINT evmon_activates - Number of event monitor activations
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
FAILED_SQL_STMTS BIGINT failed_sql_stmts - Failed statement operations
FILES_CLOSED BIGINT files_closed - Database files closed
HASH_JOIN_OVERFLOWS BIGINT hash_join_overflows - Hash join overflows
HASH_JOIN_SMALL_OVERFLOWS BIGINT hash_join_small_overflows - Hash join small overflows
INT_AUTO_REBINDS BIGINT int_auto_rebinds - Internal automatic rebinds
INT_COMMITS BIGINT int_commits - Internal commits
INT_ROLLBACKS BIGINT int_rollbacks - Internal rollbacks
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
LOCK_ESCALS BIGINT lock_escals - Number of lock escalations
LOCK_TIMEOUTS BIGINT lock_timeouts - Number of lock timeouts
LOCK_WAIT_TIME BIGINT lock_wait_time - Time waited on locks
LOCK_WAITS BIGINT lock_waits - Lock waits
LOG_FILE_ARCHIVE BIGINT  
LOG_FILE_NUM_CURR BIGINT  
LOG_FILE_NUM_FIRST BIGINT  
LOG_FILE_NUM_LAST BIGINT  
LOG_HELD_BY_DIRTY_PAGES BIGINT log_held_by_dirty_pages - Amount of log space accounted for by dirty pages
LOG_READ_TIME BIGINT log_read_time - Log read time
LOG_READS BIGINT log_reads - Number of log pages read
LOG_TO_REDO_FOR_RECOVERY BIGINT log_to_redo_for_recovery - Amount of log to be redone for recovery
LOG_WRITE_TIME BIGINT log_write_time - Log write time
LOG_WRITES BIGINT log_writes - Number of log pages written
NUM_LOG_BUFF_FULL BIGINT  
NUM_LOG_DATA_IN_BUFF BIGINT  
NUM_LOG_PART_PAGE_IO BIGINT num_log_part_page_io - Number of partial log page writes
NUM_LOG_READ_IO BIGINT num_log_read_io - Number of log reads
NUM_LOG_WRITE_IO BIGINT num_log_write_io - Number of log writes
NUM_THRESHOLD_VIOLATIONS INTEGER num_threshold_violations - Number of threshold violations
OLAP_FUNC_OVERFLOWS BIGINT olap_func_overflows - OLAP function overflows
PARTIAL_RECORD SMALLINT partial_record - Partial record
PKG_CACHE_INSERTS BIGINT pkg_cache_inserts - Package cache inserts
PKG_CACHE_LOOKUPS BIGINT pkg_cache_lookups - Package cache lookups
PKG_CACHE_NUM_OVERFLOWS BIGINT pkg_cache_num_overflows - Package cache overflows
PKG_CACHE_SIZE_TOP BIGINT pkg_cache_size_top - Package cache high watermark
POOL_ASYNC_DATA_READ_REQS BIGINT pool_async_data_read_reqs - Buffer pool asynchronous read requests
POOL_ASYNC_DATA_READS BIGINT pool_async_data_reads - Buffer pool asynchronous data reads
POOL_ASYNC_DATA_WRITES BIGINT pool_async_data_writes - Buffer pool asynchronous data writes
POOL_ASYNC_INDEX_READ_REQS BIGINT pool_async_index_read_reqs - Buffer pool asynchronous index read requests
POOL_ASYNC_INDEX_READS BIGINT pool_async_index_reads - Buffer pool asynchronous index reads
POOL_ASYNC_INDEX_WRITES BIGINT pool_async_index_writes - Buffer pool asynchronous index writes
POOL_ASYNC_READ_TIME BIGINT pool_async_read_time - Buffer pool asynchronous read time
POOL_ASYNC_WRITE_TIME BIGINT pool_async_write_time - Buffer pool asynchronous write time
POOL_ASYNC_XDA_READ_REQS BIGINT pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests
POOL_ASYNC_XDA_READS BIGINT pool_async_xda_reads - Buffer pool asynchronous XDA data reads
POOL_ASYNC_XDA_WRITES BIGINT pool_async_xda_writes - Buffer pool asynchronous XDA data writes
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_DATA_WRITES BIGINT pool_data_writes - Buffer pool data writes
POOL_DRTY_PG_STEAL_CLNS BIGINT pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered
POOL_DRTY_PG_THRSH_CLNS BIGINT pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered
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_INDEX_WRITES BIGINT pool_index_writes - Buffer pool index writes
POOL_LSN_GAP_CLNS BIGINT pool_lsn_gap_clns - Buffer pool log space cleaners triggered
POOL_NO_VICTIM_BUFFER BIGINT pool_no_victim_buffer - Buffer pool no victim buffers
POOL_READ_TIME BIGINT pool_read_time - Total buffer pool physical read time
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_WRITE_TIME BIGINT pool_write_time - Total buffer pool physical write time
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
POOL_XDA_WRITES BIGINT pool_xda_writes - Buffer pool XDA data writes
POST_SHRTHRESHOLD_HASH_JOINS BIGINT post_shrthreshold_hash_joins - Post threshold hash joins
POST_SHRTHRESHOLD_SORTS BIGINT post_shrthreshold_sorts - Post shared threshold sorts
PREFETCH_WAIT_TIME BIGINT prefetch_wait_time - Time waited for prefetch
ROLLBACK_SQL_STMTS BIGINT rollback_sql_stmts - Rollback statements attempted
ROWS_DELETED BIGINT rows_deleted - Rows deleted
ROWS_INSERTED BIGINT rows_inserted - Rows inserted
ROWS_READ BIGINT rows_read - Rows read
ROWS_SELECTED BIGINT rows_selected - Rows selected
ROWS_UPDATED BIGINT rows_updated - Rows updated
SEC_LOG_USED_TOP BIGINT sec_log_used_top - Maximum secondary log space used
SELECT_SQL_STMTS BIGINT select_sql_stmts - Select SQL statements executed
SERVER_PLATFORM INTEGER server_platform - Server operating system
SORT_OVERFLOWS BIGINT sort_overflows - Sort overflows
SORT_SHRHEAP_TOP BIGINT sort_shrheap_top - Sort share heap high watermark
STATIC_SQL_STMTS BIGINT static_sql_stmts - Static SQL statements attempted
STATS_CACHE_SIZE BIGINT stats_cache_size - Size of statistics cache
STATS_FABRICATE_TIME BIGINT stats_fabricate_time - Total time spent on statistics fabrication activities
STATS_FABRICATIONS BIGINT stats_fabrications - Total number of statistics fabrications
SYNC_RUNSTATS BIGINT sync_runstats - Total number of synchronous RUNSTATS activities
SYNC_RUNSTATS_TIME BIGINT sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
TOT_LOG_USED_TOP BIGINT tot_log_used_top - Maximum total log space used
TOTAL_CONS BIGINT total_cons - Connects since database activation
TOTAL_HASH_JOINS BIGINT total_hash_joins - Total hash joins
TOTAL_HASH_LOOPS BIGINT total_hash_loops - Total hash loops
TOTAL_OLAP_FUNCS BIGINT total_olap_funcs - Total OLAP functions
TOTAL_SORT_TIME BIGINT total_sort_time - Total sort time
TOTAL_SORTS BIGINT total_sorts - Total sorts
UID_SQL_STMTS BIGINT uid_sql_stmts - UPDATE/INSERT/DELETE SQL statements executed
UNREAD_PREFETCH_PAGES BIGINT unread_prefetch_pages - Unread prefetch pages
X_LOCK_ESCALS BIGINT x_lock_escals - Exclusive lock escalations
XQUERY_STMTS BIGINT xquery_stmts - XQuery Statements Attempted
Table 3. Information returned for a database event monitor: Default table name: DBMEMUSE_evmon-name
Column name Data type Description
EVMON_ACTIVATES BIGINT evmon_activates - Number of event monitor activations
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
POOL_CUR_SIZE BIGINT pool_cur_size - Current size of memory pool
POOL_ID BIGINT pool_id - Memory pool identifier
POOL_MAX_SIZE BIGINT  
POOL_SECONDARY_ID CHARACTER(32) pool_secondary_id - Memory pool secondary identifier
POOL_WATERMARK BIGINT pool_watermark - Memory pool watermark
Table 4. Information returned for a database event monitor: Default table name: CONTROL_evmon-name
Column name Data type Description
EVENT_MONITOR_NAME VARCHAR(128) event_monitor_name - Event monitor name
MESSAGE VARCHAR(128) message - Control table message
MESSAGE_TIME TIMESTAMP message_time - Timestamp control table message