Information written to tables for a table space event monitor

Information written by a table space event monitor when the WRITE TO TABLE option is specified.

The sections that follows illustrates the output of a table space event monitor when the WRITE TO TABLE option is used on the CREATE EVENT MONITOR statement. For information about the output returned when the event monitor writes to a file or named pipe, see Event monitor self-describing data stream.
Table 1. Tables produced by TABLESPACE 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
TABLESPACE_evmon-name event_tablespace
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.

Tables produced

Table 2. Information returned for a table space event monitor: Default table name: TABLESPACE_evmon-name
Column Name Data Type Description
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
EVENT_TIME TIMESTAMP event_time - Event time
EVMON_ACTIVATES BIGINT evmon_activates - Number of event monitor activations
EVMON_FLUSHES BIGINT evmon_flushes - Number of event monitor flushes
FILES_CLOSED BIGINT files_closed - Database files closed
PARTIAL_RECORD SMALLINT partial_record - Partial record
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_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_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_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
TABLESPACE_FS_CACHING SMALLINT fs_caching - File system caching
TABLESPACE_NAME VARCHAR(18) tablespace_name - Table space name
UNREAD_PREFETCH_PAGES BIGINT unread_prefetch_pages - Unread prefetch pages
Table 3. Information returned for a table space 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