Information written to tables for a table event monitor

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

The sections that follows illustrates the output of a table 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 TABLE 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
TABLE_evmon-name event_table
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 event monitor: Default table name: TABLE_evmon-name
Column name Data type Description
DATA_OBJECT_PAGES BIGINT data_object_pages - Data object pages
DATA_PARTITION_ID INTEGER data_partition_id - Data partition identifier
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
INDEX_OBJECT_PAGES BIGINT index_object_pages - Index object pages
LOB_OBJECT_PAGES BIGINT lob_object_pages - LOB object pages
LONG_OBJECT_PAGES BIGINT long_object_pages - Long object pages
OVERFLOW_ACCESSES BIGINT overflow_accesses - Accesses to overflowed records
PAGE_REORGS BIGINT page_reorgs - Page reorganizations
PARTIAL_RECORD SMALLINT partial_record - Partial record
ROWS_READ BIGINT rows_read - Rows read
ROWS_WRITTEN BIGINT rows_written - Rows written
TABLE_NAME VARCHAR(128) table_name - Default table name
TABLE_SCHEMA VARCHAR(128) table_schema - Table schema name
TABLE_TYPE BIGINT table_type - Table type
TABLESPACE_ID BIGINT tablespace_id - Table space identification
XDA_OBJECT_PAGES BIGINT xda_object_pages - XDA Object Pages
Table 3. Information returned for a table 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