Event monitor logical data groups and monitor elements
Monitor
elements that are often useful to examine together are grouped in logical
data groups.
All event monitors use logical data
groups in one way or another. For some event
monitor types, you can specify what information you want to collect
by specifying the logical data groups for which you want information
recorded. Logical data groups are also used to group data together
in the output event monitors generate; for example, event monitors
that write to tables generally create one table for each logical data
group of monitor elements.
The following table lists the logical data groupings and
monitor elements that can be returned by event monitoring.
- changesummary logical data group
- dbdbmcfg logical data group
- ddlstmtexec logical data group
- dllock logical data group
- event_activity logical data group
- event_activitymetrics logical data group
- event_activitystmt logical data group
- event_activityvals logical data group
- event_bufferpool logical data group
- event_conn logical data group
- event_connheader logical data group
- event_connmemuse logical data group
- event_data_value logical data group
- event_db logical data group
- event_dbheader logical data group
- event_dbmemuse logical data group
- event_deadlock logical data group
- event_detailed_dlconn logical data group
- event_dlconn logical data group
- event_histogrambin logical data group
- event_log_header logical data group
- event_overflow logical data group
- event_qstats logical data group
- event_osmetrics logical data group
- event_scmetrics logical data group
- event_scstats logical data group
- event_start logical data group
- event_stmt logical data group
- event_stmt_history logical data group
- event_subsection logical data group
- event_table logical data group
- event_tablespace logical data group
- event_thresholdviolations logical data group
- event_wcstats logical data group
- event_wlmetrics logical data group
- event_wlstats logical data group
- event_xact logical data group
- evmonstart logical data group
- lock logical data group
- lock_participants logical data group
- lock_participant_activities logical data group
- lock_activity_values logical data group
- pkgcache logical data group
- pkgcache_metrics logical data group
- pkgcache_stmt_args logical data group
- regvar logical data group
- sqlca logical data group
- txncompletion logical data group
- uow logical data group
- uow_metrics logical data group
- uow_package_list logical data group
- uow_executable_list logical data group
- utillocation logical data group
- utilphase logical data group
- utilstart logical data group
- utilstop logical data group
changesummary logical data group
- event_id - Event ID monitor element
- event_type - Event Type monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- coord_member - Coordinator member monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- application_handle - Application handle monitor element
- system_auth_id - System authorization identifier monitor element
- session_auth_id - Session authorization ID monitor element
- client_platform - Client operating platform monitor element
- client_protocol - Client communication protocol monitor element
- client_port_number - Client port number monitor element
- client_pid - Client process ID monitor element
- client_hostname - Client hostname monitor element
- client_wrkstnname - Client workstation name monitor element
- client_acctng - Client accounting string monitor element
- client_userid - Client user ID monitor element
- client_applname - Client application name monitor element
- backup_timestamp - Backup timestamp monitor element
dbdbmcfg logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- cfg_name - Configuration name monitor element
- cfg_value - Configuration value monitor element
- cfg_value_flags - Configuration value flags monitor element
- cfg_old_value - Configuration old value monitor element
- cfg_old_value_flags - Configuration old value flags monitor element
- cfg_collection_type - Configuration collection type monitor element
- deferred - Deferred monitor element
ddlstmtexec logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- global_transaction_id - Global transaction identifier monitor element
- local_transaction_id - Local transaction identifier monitor element
- savepoint_id - Savepoint ID monitor element
- uow_id - Unit of work ID monitor element
- ddl_classification - DDL classification monitor element
- stmt_text - SQL statement text monitor element
dllock logical data group
- data_partition_id - Data partition identifier monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_name - Lock name monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_status - Lock status monitor element
- node_number - Node Number monitor element
- table_file_id - Table file ID monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
Note: The underlying implementation
for this logical data group is the snapshot monitor LOCK logical data
group. If you examine the output for this logical group in the self-describing
stream used for the file and pipe output options, you can see that
the LOCK group is used to generate the output.
event_activity logical data group
- act_exec_time - Activity execution time monitor element
- activate_timestamp - Activate timestamp monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- activity_type - Activity type monitor element
- address - IP address from which the connection was initiated
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- arm_correlator - Application response measurement correlator monitor element
- coord_partition_num - Coordinator partition number monitor element
- db_work_action_set_id - Database work action set ID monitor element
- db_work_class_id - Database work class ID monitor element
- details_xml - Details XML monitor element
- intra_parallel_state - Current state of intrapartition parallelism monitor element
- num_remaps - Number of remaps monitor element
- parent_activity_id - Parent activity ID monitor element
- parent_uow_id - Parent unit of work ID monitor element
- partial_record - Partial Record monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element
- sc_work_action_set_id - Service class work action set ID monitor element
- sc_work_class_id - Service class work class ID monitor element
- section_actuals - Section actuals monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- session_auth_id - Session authorization ID monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_overflows - Sort overflows monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- sqlca - SQL Communications Area (SQLCA) monitor element
- time_completed - Time completed monitor element
- time_created - Time created monitor element
- time_started - Time started monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
- uow_id - Unit of work ID monitor element
- workload_id - Workload ID monitor element
- workload_occurrence_id - Workload occurrence identifier monitor element
- prep_time - Preparation time monitor element
- query_card_estimate - Query Number of Rows Estimate monitor element
- query_cost_estimate - Query cost estimate monitor element
- rows_fetched - Rows fetched monitor element
- rows_modified - Rows modified monitor element
- rows_returned - Rows returned monitor element
- system_cpu_time - System CPU time monitor element
- user_cpu_time - User CPU time monitor element
- wl_work_action_set_id - Workload work action set identifier monitor element
- wl_work_class_id - Workload work class identifier monitor element
- mon_interval_id - Monitor interval identifier monitor element
- member - Database member monitor element
- query_data_tag_list - Estimated query data tag list monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- utility_invocation_id - Utility invocation ID monitor element
event_activitymetrics logical data group
- audit_events_total - Total audit events monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- coord_stmt_exec_time - Execution time for statement by coordinator agent monitor element
- deadlocks - Deadlocks detected monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- lock_escals - Number of lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- rows_modified - Rows modified monitor element
- rows_read - Rows read monitor element
- rows_returned - Rows returned monitor element
- sort_overflows - Sort overflows monitor element
- stmt_exec_time - Statement execution time monitor element
- thresh_violations - Number of threshold violations monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_cpu_time - Total CPU time monitor element
- total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
- total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_routine_invocations - Total routine invocations monitor elements
- total_routine_non_sect_proc_time - Non-section processing time monitor element
- total_routine_non_sect_time - Non-section routine execution time monitor elements
- total_routine_time - Total routine time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sort_time - Total section sort time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_time - Total section time monitor element
- total_sorts - Total sorts monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_updated - Rows updated monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
event_activitystmt logical data group
- activate_timestamp - Activate timestamp monitor element
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- appl_id - Application ID monitor element
- comp_env_desc - Compilation environment monitor element
- creator - Application Creator monitor element
- eff_stmt_text - Effective statement text monitor element
- executable_id - Executable ID monitor element
- intra_parallel_state - Current state of intrapartition parallelism monitor element
- package_name - Package name monitor element
- planid - Query plan ID monitor element
- num_routines - Number of routines monitor element
- package_version_id - Package version monitor element
- query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element
- routine_id - Routine ID monitor element
- section_env - Section environment monitor element
- section_number - Section number monitor element
- semantic_env_id - Query semantic compilation environment ID monitor element
- stmtid - Query statement ID monitor element
- stmt_first_use_time - Statement first use timestamp monitor element
- stmt_invocation_id - Statement invocation identifier monitor element
- stmt_isolation - Statement isolation monitor element
- stmt_last_use_time - Statement last use timestamp monitor element
- stmt_lock_timeout - Statement lock timeout monitor element
- stmt_nest_level - Statement nesting level monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_query_id - Statement query identifier monitor element
- stmt_source_id - Statement source identifier monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- stmtno - Statement number monitor element
- uow_id - Unit of work ID monitor element
event_activityvals logical data group
- activate_timestamp - Activate timestamp monitor element
- activity_id - Activity ID monitor element
- activity_secondary_id - Activity secondary ID monitor element
- appl_id - Application ID monitor element
- intra_parallel_state - Current state of intrapartition parallelism monitor element
- query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element
- stmt_value_data - Value data monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
- uow_id - Unit of work ID monitor element
event_bufferpool logical data group
- bp_id - Buffer pool identifier monitor element
- bp_name - Buffer pool name monitor element
- db_name - Database name monitor element
- db_path - Database Path monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- event_time - Event Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- files_closed - Database files closed monitor element
- partial_record - Partial Record monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- block_ios - Number of block I/O requests monitor element
- pages_from_block_ios - Total number of pages read by block I/O monitor element
- pages_from_vectored_ios - Total number of pages read by vectored I/O monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- vectored_ios - Number of vectored I/O requests monitor element
event_conn logical data group
- acc_curs_blk - Accepted Block Cursor Requests monitor element
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_priority - Application Agent Priority monitor element
- appl_priority_type - Application Priority Type monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- authority_bitmap - User authorization level monitor element
- authority_lvl - User authorization level monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cat_cache_overflows - Catalog Cache Overflows monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disconn_time - Database Deactivation Timestamp monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- int_auto_rebinds - Internal Automatic Rebinds monitor element
- int_commits - Internal commits monitor element
- int_deadlock_rollbacks - Internal Rollbacks Due To Deadlock monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- lock_escalation - Lock escalation monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partial_record - Partial Record monitor element
- int_rows_updated - Internal Rows Updated monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- priv_workspace_num_overflows - Private Workspace Overflows monitor element
- priv_workspace_section_inserts - Private Workspace Section Inserts monitor element
- priv_workspace_section_lookups - Private Workspace Section Lookups monitor element
- priv_workspace_size_top - Maximum Private Workspace Size monitor element
- rej_curs_blk - Rejected Block Cursor Requests monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_read - Rows read monitor element
- rows_selected - Rows Selected monitor element
- rows_written - Rows Written monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- sequence_no - Sequence number monitor element
- shr_workspace_num_overflows - Shared Workspace Overflows monitor element
- shr_workspace_section_inserts - Shared Workspace Section Inserts monitor element
- shr_workspace_section_lookups - Shared Workspace Section Lookups monitor element
- shr_workspace_size_top - Maximum Shared Workspace Size monitor element
- sort_overflows - Sort overflows monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- system_cpu_time - System CPU time monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_sec_cons - Secondary Connections monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- user_cpu_time - User CPU time monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
- appl_status - Application status monitor element
- cat_cache_size_top - Catalog cache high watermark monitor element
- coord_node - Coordinating Node monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- lock_escals - Number of lock escalations monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_updated - Rows updated monitor element
- cat_cache_heap_full - Catalog cache heap full monitor element monitor element
event_connheader logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- auth_id - Authorization ID monitor element
- client_db_alias - Database Alias Used by Application monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- conn_time - Time of database connection monitor element
- corr_token - DRDA Correlation Token monitor element
- execution_id - User Login ID monitor element
- node_number - Node Number monitor element
- sequence_no - Sequence number monitor element
- territory_code - Database Territory Code monitor element
- client_nname - Client name monitor element
event_connmemuse logical data group
- node_number - Node Number monitor element
- pool_config_size - Configured Size of Memory Pool monitor element
- pool_cur_size - Current Size of Memory Pool monitor element
- pool_id - Memory Pool Identifier monitor element
- pool_secondary_id - Memory Pool Secondary Identifier monitor element
- pool_watermark - Memory Pool Watermark monitor element
- appl_id - Application ID monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- POOL_LIST_ID
- POOL_MAX_SIZE
event_data_value logical data group
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- participant_no - Participant within Deadlock monitor element
- stmt_history_id - Statement history identifier monitor element
- stmt_value_data - Value data monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
event_db logical data group
- active_hash_joins - Active hash joins monitor element
- appl_section_inserts - Section Inserts monitor element
- appl_section_lookups - Section Lookups monitor element
- async_runstats - Total number of asynchronous RUNSTATS requests monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- blocks_pending_cleanup - Pending cleanup rolled-out blocks monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- cat_cache_overflows - Catalog Cache Overflows monitor element
- cat_cache_size_top - Catalog cache high watermark monitor element
- catalog_node - Catalog Node Number monitor element
- catalog_node_name - Catalog Node Network Name monitor element
- commit_sql_stmts - Commit Statements Attempted monitor element
- connections_top - Maximum Number of Concurrent Connections monitor element
- db_heap_top - Maximum Database Heap Allocated monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- deadlocks - Deadlocks detected monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- disconn_time - Database Deactivation Timestamp monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- files_closed - Database files closed monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- int_auto_rebinds - Internal Automatic Rebinds monitor element
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- lock_escals - Number of lock escalations monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- log_held_by_dirty_pages - Amount of Log Space Accounted for by Dirty Pages monitor element
- log_read_time - Log Read Time monitor element
- log_reads - Number of Log Pages Read monitor element
- log_to_redo_for_recovery - Amount of Log to be Redone for Recovery monitor element
- log_write_time - Log Write Time monitor element
- log_writes - Number of Log Pages Written monitor element
- num_log_read_io - Number of Log Reads monitor element
- num_log_write_io - Number of Log Writes monitor element
- num_threshold_violations - Number of threshold violations monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- partial_record - Partial Record monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- pkg_cache_num_overflows - Package Cache Overflows monitor element
- pkg_cache_size_top - Package cache high watermark monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_drty_pg_steal_clns - Buffer pool victim page cleaners triggered monitor element
- pool_drty_pg_thrsh_clns - Buffer pool threshold cleaners triggered monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_lsn_gap_clns - Buffer pool log space cleaners triggered monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- priv_workspace_num_overflows - Private Workspace Overflows monitor element
- priv_workspace_section_inserts - Private Workspace Section Inserts monitor element
- priv_workspace_section_lookups - Private Workspace Section Lookups monitor element
- priv_workspace_size_top - Maximum Private Workspace Size monitor element
- rollback_sql_stmts - Rollback Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_read - Rows read monitor element
- rows_selected - Rows Selected monitor element
- rows_updated - Rows updated monitor element
- sec_log_used_top - Maximum Secondary Log Space Used monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- server_platform - Server Operating System monitor element
- shr_workspace_num_overflows - Shared Workspace Overflows monitor element
- shr_workspace_section_inserts - Shared Workspace Section Inserts monitor element
- shr_workspace_section_lookups - Shared Workspace Section Lookups monitor element
- shr_workspace_size_top - Maximum Shared Workspace Size monitor element
- sort_overflows - Sort overflows monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- stats_cache_size - Size of statistics cache monitor element
- stats_fabricate_time - Total time spent on statistics fabrication activities monitor element
- stats_fabrications - Total number of statistics fabrications monitor elements
- sync_runstats - Total number of synchronous RUNSTATS activities monitor element
- sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
- tot_log_used_top - Maximum Total Log Space Used monitor element
- total_cons - Connects Since Database Activation monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- unread_prefetch_pages - Unread prefetch pages monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
- elapsed_exec_time - Statement Execution Elapsed Time monitor element
- num_log_part_page_io - Number of Partial Log Page Writes monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- cat_cache_heap_full - Catalog cache heap full monitor element monitor element
- LOG_FILE_ARCHIVE
- LOG_FILE_NUM_CURR
- LOG_FILE_NUM_FIRST
- LOG_FILE_NUM_LAST
- NUM_LOG_BUFF_FULL
- NUM_LOG_DATA_IN_BUFF
event_dbheader logical data group
event_dbmemuse logical data group
- node_number - Node Number monitor element
- pool_config_size - Configured Size of Memory Pool monitor element
- pool_cur_size - Current Size of Memory Pool monitor element
- pool_id - Memory Pool Identifier monitor element
- pool_watermark - Memory Pool Watermark monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- pool_secondary_id - Memory Pool Secondary Identifier monitor element
- POOL_MAX_SIZE
event_deadlock logical data group
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- dl_conns - Connections involved in deadlock monitor element
- evmon_activates - Number of event monitor activations monitor element
- rolled_back_agent_id - Rolled Back Agent monitor element
- rolled_back_appl_id - Rolled Back Application monitor element
- rolled_back_participant_no - Rolled back application participant monitor element
- rolled_back_sequence_no - Rolled Back Sequence Number monitor element
- start_time - Event Start Time monitor element
event_detailed_dlconn logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_id_holding_lk - Application ID Holding Lock monitor element
- blocking_cursor - Blocking Cursor monitor element
- consistency_token - Package consistency token monitor element
- creator - Application Creator monitor element
- cursor_name - Cursor Name monitor element
- data_partition_id - Data partition identifier monitor element
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- lock_escalation - Lock escalation monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_node - Lock Node monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- locks_held - Locks held monitor element
- locks_in_list - Number of Locks Reported monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- participant_no - Participant within Deadlock monitor element
- participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
- section_number - Section number monitor element
- sequence_no - Sequence number monitor element
- sequence_no_holding_lk - Sequence Number Holding Lock monitor element
- start_time - Event Start Time monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_hold_count - Lock hold count monitor element
- lock_name - Lock name monitor element
- lock_release_flags - Lock release flags monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
event_dlconn logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_id_holding_lk - Application ID Holding Lock monitor element
- data_partition_id - Data partition identifier monitor element
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_name - Lock name monitor element
- lock_node - Lock Node monitor element
- lock_object_name - Lock Object Name monitor element
- lock_object_type - Lock object type waited on monitor element
- lock_release_flags - Lock release flags monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- participant_no - Participant within Deadlock monitor element
- participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
- sequence_no - Sequence number monitor element
- sequence_no_holding_lk - Sequence Number Holding Lock monitor element
- start_time - Event Start Time monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- tablespace_name - Table space name monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
event_histogrambin logical data group
- bin_id - Histogram bin identifier monitor element
- bottom - Histogram bin bottom monitor element
- histogram_type - Histogram type monitor element
- number_in_bin - Number in bin monitor element
- service_class_id - Service class ID monitor element
- statistics_timestamp - Statistics timestamp monitor element
- top - Histogram bin top monitor element
- work_action_set_id - Work action set ID monitor element
- work_class_id - Work class ID monitor element
- workload_id - Workload ID monitor element
- mon_interval_id - Monitor interval identifier monitor element
event_log_header logical data group
- byte_order - Byte Order of Event Data monitor element
- codepage_id - ID of Code Page Used by Application monitor element
- event_monitor_name - Event Monitor Name monitor element
- num_nodes_in_db2_instance - Number of Nodes in Partition monitor element
- server_instance_name - Server Instance Name monitor element
- server_prdid - Server Product/Version ID monitor element
- territory_code - Database Territory Code monitor element
- version - Version of Monitor Data monitor element
event_overflow logical data group
event_qstats logical data group
- last_wlm_reset - Time of last reset monitor element
- queue_assignments_total - Queue assignments total monitor element
- queue_size_top - Queue size top monitor element
- queue_time_total - Queue time total monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- statistics_timestamp - Statistics timestamp monitor element
- threshold_domain - Threshold domain monitor element
- threshold_name - Threshold name monitor element
- threshold_predicate - Threshold predicate monitor element
- thresholdid - Threshold ID monitor element
- work_action_set_name - Work action set name monitor element
- work_class_name - Work class name monitor element
- mon_interval_id - Monitor interval identifier monitor element
event_osmetrics logical data group
- statistics_timestamp - Statistics timestamp monitor element
- last_wlm_reset - Time of last reset monitor element
- member - Database member monitor element
- mon_interval_id - Monitor interval identifier monitor element
- cpu_total - Number of CPUs monitor element
- cpu_online - Number of CPUs online monitor element
- cpu_configured - Number of configured CPUs monitor element
- cpu_speed - CPU clock speed monitor element
- cpu_timebase - Frequency of timebase register increment monitor element
- cpu_hmt_degree - Number of logical CPUs monitor element
- cpu_cores_per_socket - Number of CPU cores per socket monitor element
- memory_total - Total physical memory monitor element
- memory_free - Amount of free physical memory monitor element
- memory_swap_total - Total swap space monitor element
- memory_swap_free - Total free swap space monitor element
- virtual_mem_total - Total virtual memory monitor element
- virtual_mem_reserved - Reserved virtual memory monitor element
- virtual_mem_free - Free virtual memory monitor element
- cpu_load_short - Processor load (short timeframe) monitor element
- cpu_load_medium - Processor load (medium timeframe) monitor element
- cpu_load_long - Processor load (long timeframe) monitor element
- cpu_usage_total - Processor usage monitor element
- cpu_user - Non-kernel processing time monitor element
- cpu_idle - Processor idle time monitor element
- cpu_iowait - IO Wait time monitor element
- cpu_system - Kernel time monitor element
- swap_page_size - Swap page size monitor element
- swap_pages_in - Pages swapped in from disk monitor element
- swap_pages_out - Pages swapped out to disk monitor element
event_scmetrics logical data group
- partition_key - Partitioning key monitor element
- last_wlm_reset - Time of last reset monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_number - Partition Number monitor element
- service_class_id - Service class ID monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- statistics_timestamp - Statistics timestamp monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- direct_read_time - Direct read time monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_write_time - Direct write time monitor element
- direct_write_reqs - Direct write requests monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- client_idle_wait_time - Client idle wait time monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- total_wait_time - Total wait time monitor element
- rqsts_completed_total - Total requests completed monitor element
- total_rqst_time - Total request time monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- total_app_rqst_time - Total application request time monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
- total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_sort_time - Total section sort time monitor element
- rows_read - Rows read monitor element
- rows_modified - Rows modified monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- total_cpu_time - Total CPU time monitor element
- act_completed_total - Total completed activities monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- pool_index_writes - Buffer pool index writes monitor element
- direct_reads - Direct reads from database monitor element
- direct_writes - Direct writes to database monitor element
- rows_returned - Rows returned monitor element
- deadlocks - Deadlocks detected monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_escals - Number of lock escalations monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- sort_overflows - Sort overflows monitor element
- audit_events_total - Total audit events monitor element
- total_rqst_mapped_in - Total request mapped-in monitor element
- total_rqst_mapped_out - Total request mapped-out monitor element
- act_rejected_total - Total rejected activities monitor element
- act_aborted_total - Total aborted activities monitor element
- total_sorts - Total sorts monitor element
- total_routine_time - Total routine time monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compilations - Total compilations monitor element
- total_compile_time - Total compile time monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorgs - Total reorganizations monitor element
- total_reorg_time - Total reorganization time monitor element
- total_load_proc_time - Total load processing time monitor element
- total_loads - Total loads monitor element
- total_load_time - Total load time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_section_time - Total section time monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_app_commits - Total application commits monitor elements
- total_commit_time - Total commit time monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_app_rollbacks - Total application rollbacks monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- thresh_violations - Number of threshold violations monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- total_routine_invocations - Total routine invocations monitor elements
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- act_rqsts_total - Total activity requests monitor elements
- total_act_wait_time - Total activity wait time monitor element
- total_act_time - Total activity time monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits_global - Lock waits global monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- total_peds - Total partial early distincts monitor element
- disabled_peds - Disabled partial early distincts monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- total_peas - Total partial early aggregations monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- total_connect_request_proc_time - Total connection or switch user request processing time monitor element
- total_connect_requests - Connection or switch user requests monitor element
- total_connect_request_time - Total connection or switch user request time monitor element
- total_connect_authentication_proc_time - Total connection authentication processing time monitor element
- total_connect_authentications - Connections or switch user authentications performed monitor element
- total_connect_authentication_time - Total connection or switch user authentication request time monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- comm_exit_wait_time - Communication exit wait time monitor element
- comm_exit_waits - Communication exit number of waits monitor element
- FCM_TQ_RECV_WAITS_TOTAL
- FCM_MESSAGE_RECV_WAITS_TOTAL
- FCM_TQ_SEND_WAITS_TOTAL
- FCM_MESSAGE_SEND_WAITS_TOTAL
- FCM_SEND_WAITS_TOTAL
- FCM_RECV_WAITS_TOTAL
- ida_send_wait_time - Time spent waiting to send data monitor element
- ida_sends_total - Number of times data sent monitor element
- ida_send_volume - Total data volume sent monitor element
- ida_recv_wait_time - Time spent waiting to receive data monitor element
- ida_recvs_total - Number of times data received monitor element
- ida_recv_volume - Total data volume received monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_updated - Rows updated monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
event_scstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_remapped_in - Activities remapped in monitor element
- act_remapped_out - Activities remapped out monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_throughput - Activity throughput monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- agg_temp_tablespace_top - Aggregate temporary table space top monitor element
- concurrent_act_top - Concurrent activity top monitor element
- concurrent_wlo_top - Concurrent workload occurrences top monitor element
- concurrent_connection_top - Concurrent connection top monitor element
- coord_act_aborted_total - Coordinator activities aborted total monitor element
- coord_act_completed_total - Coordinator activities completed total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- coord_act_rejected_total - Coordinator activities rejected total monitor element
- cost_estimate_top - Cost estimate top monitor element
- cpu_utilization - CPU utilization monitor element
- details_xml - Details XML monitor element
- last_wlm_reset - Time of last reset monitor element
- metrics - Metrics monitor element.)
- request_exec_time_avg - Request execution time average monitor element
- rows_returned_top - Actual rows returned top monitor element
- service_class_id - Service class ID monitor element
- service_subclass_name - Service subclass name monitor element
- service_superclass_name - Service superclass name monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- uow_completed_total - Total completed units of work monitor element
- uow_lifetime_avg - Unit of work lifetime average monitor element
- uow_throughput - Unit of work throughput monitor element
- uow_total_time_top - UOW total time top monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- mon_interval_id - Monitor interval identifier monitor element
event_start logical data group
event_stmt logical data group
- agent_id - Application handle (agent ID) monitor element
- agents_top - Number of Agents Created monitor element
- appl_id - Application ID monitor element
- blocking_cursor - Blocking Cursor monitor element
- consistency_token - Package consistency token monitor element
- creator - Application Creator monitor element
- cursor_name - Cursor Name monitor element
- fetch_count - Number of Successful Fetches monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- partial_record - Partial Record monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- section_number - Section number monitor element
- sequence_no - Sequence number monitor element
- sort_overflows - Sort overflows monitor element
- sql_req_id - Request Identifier for SQL Statement monitor element
- sqlca - SQL Communications Area (SQLCA) monitor element
- start_time - Event Start Time monitor element
- stats_fabricate_time - Total time spent on statistics fabrication activities monitor element
- stmt_operation/operation - Statement operation monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- stop_time - Event Stop Time monitor element
- sync_runstats_time - Total time spent on synchronous RUNSTATS activities monitor element
- system_cpu_time - System CPU time monitor element
- total_sort_time - Total sort time monitor element
- total_sorts - Total sorts monitor element
- user_cpu_time - User CPU time monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
event_stmt_history logical data group
- comp_env_desc - Compilation environment monitor element
- creator - Application Creator monitor element
- deadlock_id - Deadlock Event Identifier monitor element
- deadlock_node - Partition Number Where Deadlock Occurred monitor element
- evmon_activates - Number of event monitor activations monitor element
- package_name - Package name monitor element
- package_version_id - Package version monitor element
- participant_no - Participant within Deadlock monitor element
- section_number - Section number monitor element
- sequence_no - Sequence number monitor element
- stmt_first_use_time - Statement first use timestamp monitor element
- stmt_history_id - Statement history identifier monitor element
- stmt_invocation_id - Statement invocation identifier monitor element
- stmt_isolation - Statement isolation monitor element
- stmt_last_use_time - Statement last use timestamp monitor element
- stmt_lock_timeout - Statement lock timeout monitor element
- stmt_nest_level - Statement nesting level monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_query_id - Statement query identifier monitor element
- stmt_source_id - Statement source identifier monitor element
- stmt_text - SQL statement text monitor element
- stmt_type - Statement type monitor element
- appl_id - Application ID monitor element
event_subsection logical data group
- agent_id - Application handle (agent ID) monitor element
- num_agents - Number of Agents Working on a Statement monitor element
- partial_record - Partial Record monitor element
- ss_exec_time - Subsection Execution Elapsed Time monitor element
- ss_node_number - Subsection Node Number monitor element
- ss_number - Subsection number monitor element
- ss_sys_cpu_time - System CPU Time used by Subsection monitor element
- ss_usr_cpu_time - User CPU Time used by Subsection monitor element
- tq_max_send_spills - Maximum number of table queue buffers overflows monitor element
- tq_rows_read - Number of Rows Read from table queues monitor element
- tq_rows_written - Number of rows written to table queues monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- appl_id - Application ID monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- sql_req_id - Request Identifier for SQL Statement monitor element
Note: This
logical data group is only generated in partitioned database environments.
event_table logical data group
- data_object_pages - Data Object Pages monitor element
- data_partition_id - Data partition identifier monitor element
- event_time - Event Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- index_object_pages - Index Object Pages monitor element
- lob_object_pages - LOB Object Pages monitor element
- long_object_pages - Long Object Pages monitor element
- overflow_accesses - Accesses to overflowed records monitor element
- page_reorgs - Page reorganizations monitor element
- partial_record - Partial Record monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- table_type - Table type monitor element
- tablespace_id - Table space identification monitor element
- xda_object_pages - XDA Object Pages monitor element
event_tablespace logical data group
- direct_read_reqs - Direct read requests monitor element
- direct_read_time - Direct read time monitor element
- direct_reads - Direct reads from database monitor element
- direct_write_reqs - Direct write requests monitor element
- direct_write_time - Direct write time monitor element
- direct_writes - Direct writes to database monitor element
- event_time - Event Time monitor element
- evmon_activates - Number of event monitor activations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
- files_closed - Database files closed monitor element
- partial_record - Partial Record monitor element
- pool_async_data_read_reqs - Buffer pool asynchronous read requests monitor element
- pool_async_data_reads - Buffer pool asynchronous data reads monitor element
- pool_async_data_writes - Buffer pool asynchronous data writes monitor element
- pool_async_index_read_reqs - Buffer pool asynchronous index read requests monitor element
- pool_async_index_reads - Buffer pool asynchronous index reads monitor element
- pool_async_index_writes - Buffer pool asynchronous index writes monitor element
- pool_async_read_time - Buffer Pool Asynchronous Read Time monitor element
- pool_async_write_time - Buffer pool asynchronous write time monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_index_writes - Buffer pool index writes monitor element
- pool_no_victim_buffer - Buffer pool no victim buffers monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- tablespace_name - Table space name monitor element
- pool_async_xda_read_reqs - Buffer pool asynchronous XDA read requests monitor element
- pool_async_xda_reads - Buffer pool asynchronous XDA data reads monitor element
- pool_async_xda_writes - Buffer pool asynchronous XDA data writes monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- TABLESPACE_FS_CACHING
- unread_prefetch_pages - Unread prefetch pages monitor element
event_thresholdviolations logical data group
- activate_timestamp - Activate timestamp monitor element
- activity_collected - Activity collected monitor element
- activity_id - Activity ID monitor element
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_hostname - Client hostname monitor element
- appl_name - Application name monitor element
- client_pid - Client process ID monitor element
- client_platform - Client operating platform monitor element
- client_port_number - Client port number monitor element
- client_prdid - Client product and version ID monitor element
- client_protocol - Client communication protocol monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- connection_start_time - Connection start time monitor element
- coord_partition_num - Coordinator partition number monitor element
- destination_service_class_id - Destination service class ID monitor element
- session_auth_id - Session authorization ID monitor element
- source_service_class_id - Source service class ID monitor element
- system_auth_id - System authorization identifier monitor element
- threshold_action - Threshold action monitor element
- threshold_maxvalue - Threshold maximum value monitor element
- threshold_predicate - Threshold predicate monitor element
- threshold_queuesize - Threshold queue size monitor element
- thresholdid - Threshold ID monitor element
- time_of_violation - Time of violation monitor element
- uow_id - Unit of work ID monitor element
- workload_id - Workload ID monitor element
event_wcstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_total - Activities total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- cost_estimate_top - Cost estimate top monitor element
- last_wlm_reset - Time of last reset monitor element
- rows_returned_top - Actual rows returned top monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- work_action_set_id - Work action set ID monitor element
- work_action_set_name - Work action set name monitor element
- work_class_id - Work class ID monitor element
- work_class_name - Work class name monitor element
- mon_interval_id - Monitor interval identifier monitor element
event_wlmetrics logical data group
- partition_key - Partitioning key monitor element
- last_wlm_reset - Time of last reset monitor element
- mon_interval_id - Monitor interval identifier monitor element
- partition_number - Partition Number monitor element
- statistics_timestamp - Statistics timestamp monitor element
- workload_id - Workload ID monitor element
- workload_name - Workload name monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- direct_read_time - Direct read time monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_write_time - Direct write time monitor element
- direct_write_reqs - Direct write requests monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- client_idle_wait_time - Client idle wait time monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- total_wait_time - Total wait time monitor element
- rqsts_completed_total - Total requests completed monitor element
- total_rqst_time - Total request time monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- total_app_rqst_time - Total application request time monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
- total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_sort_time - Total section sort time monitor element
- rows_read - Rows read monitor element
- rows_modified - Rows modified monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- total_cpu_time - Total CPU time monitor element
- act_completed_total - Total completed activities monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- pool_index_writes - Buffer pool index writes monitor element
- direct_reads - Direct reads from database monitor element
- direct_writes - Direct writes to database monitor element
- rows_returned - Rows returned monitor element
- deadlocks - Deadlocks detected monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_escals - Number of lock escalations monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- sort_overflows - Sort overflows monitor element
- audit_events_total - Total audit events monitor element
- act_rejected_total - Total rejected activities monitor element
- act_aborted_total - Total aborted activities monitor element
- total_sorts - Total sorts monitor element
- total_routine_time - Total routine time monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compilations - Total compilations monitor element
- total_compile_time - Total compile time monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorgs - Total reorganizations monitor element
- total_reorg_time - Total reorganization time monitor element
- total_load_proc_time - Total load processing time monitor element
- total_loads - Total loads monitor element
- total_load_time - Total load time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_section_time - Total section time monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_app_commits - Total application commits monitor elements
- total_commit_time - Total commit time monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_app_rollbacks - Total application rollbacks monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- thresh_violations - Number of threshold violations monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- total_routine_invocations - Total routine invocations monitor elements
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- act_rqsts_total - Total activity requests monitor elements
- total_act_wait_time - Total activity wait time monitor element
- total_act_time - Total activity time monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits_global - Lock waits global monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor element
- pool_queued_async_other_reqs - Other requests handled by prefetchers monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor element
- pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor element
- pool_failed_async_data_reqs - Failed data prefetch requests monitor element
- pool_failed_async_index_reqs - Failed index prefetch requests monitor element
- pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor element
- pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor element
- pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor element
- pool_failed_async_other_reqs - Failed non-prefetch requests monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- total_peds - Total partial early distincts monitor element
- disabled_peds - Disabled partial early distincts monitor element
- post_threshold_peds - Partial early distincts threshold monitor element
- total_peas - Total partial early aggregations monitor element
- post_threshold_peas - Partial early aggregation threshold monitor element
- tq_sort_heap_requests - Table queue sort heap requests monitor element
- tq_sort_heap_rejections - Table queue sort heap rejections monitor element
- total_connect_request_proc_time - Total connection or switch user request processing time monitor element
- total_connect_requests - Connection or switch user requests monitor element
- total_connect_request_time - Total connection or switch user request time monitor element
- total_connect_authentication_proc_time - Total connection authentication processing time monitor element
- total_connect_authentications - Connections or switch user authentications performed monitor element
- total_connect_authentication_time - Total connection or switch user authentication request time monitor element
- prefetch_wait_time - Time waited for prefetch monitor element
- prefetch_waits - Prefetcher wait count monitor element
- pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor element
- pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor element
- pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor element
- comm_exit_wait_time - Communication exit wait time monitor element
- comm_exit_waits - Communication exit number of waits monitor element
- FCM_TQ_RECV_WAITS_TOTAL
- FCM_MESSAGE_RECV_WAITS_TOTAL
- FCM_TQ_SEND_WAITS_TOTAL
- FCM_MESSAGE_SEND_WAITS_TOTAL
- FCM_SEND_WAITS_TOTAL
- FCM_RECV_WAITS_TOTAL
- ida_send_wait_time - Time spent waiting to send data monitor element
- ida_sends_total - Number of times data sent monitor element
- ida_send_volume - Total data volume sent monitor element
- ida_recv_wait_time - Time spent waiting to receive data monitor element
- ida_recvs_total - Number of times data received monitor element
- ida_recv_volume - Total data volume received monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_updated - Rows updated monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
event_wlstats logical data group
- act_cpu_time_top - Activity CPU time top monitor element
- act_rows_read_top - Activity rows read top monitor element
- act_throughput - Activity throughput monitor element
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- concurrent_wlo_act_top - Concurrent WLO activity top monitor element
- concurrent_wlo_top - Concurrent workload occurrences top monitor element
- coord_act_aborted_total - Coordinator activities aborted total monitor element
- coord_act_completed_total - Coordinator activities completed total monitor element
- coord_act_est_cost_avg - Coordinator activity estimated cost average monitor element
- coord_act_exec_time_avg - Coordinator activities execution time average monitor element
- coord_act_interarrival_time_avg - Coordinator activity arrival time average monitor element
- coord_act_lifetime_avg - Coordinator activity lifetime average monitor element
- coord_act_lifetime_top - Coordinator activity lifetime top monitor element
- coord_act_queue_time_avg - Coordinator activity queue time average monitor element
- coord_act_rejected_total - Coordinator activities rejected total monitor element
- cost_estimate_top - Cost estimate top monitor element
- cpu_utilization - CPU utilization monitor element
- details_xml - Details XML monitor element
- last_wlm_reset - Time of last reset monitor element
- lock_wait_time_top - Lock wait time top monitor element
- metrics - Metrics monitor element
- rows_returned_top - Actual rows returned top monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- statistics_timestamp - Statistics timestamp monitor element
- temp_tablespace_top - Temporary table space top monitor element
- total_cpu_time - Total CPU time monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- uow_completed_total - Total completed units of work monitor element
- uow_lifetime_avg - Unit of work lifetime average monitor element
- uow_throughput - Unit of work throughput monitor element
- uow_total_time_top - UOW total time top monitor element
- wlo_completed_total - Workload occurrences completed total monitor element
- workload_id - Workload ID monitor element
- workload_name - Workload name monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- lock_wait_time_global_top - Top global lock wait time monitor element
- mon_interval_id - Monitor interval identifier monitor element
event_xact logical data group
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- lock_escals - Number of lock escalations monitor element
- lock_wait_time - Time waited on locks monitor element
- locks_held_top - Maximum number of locks held monitor element
- partial_record - Partial Record monitor element
- prev_uow_stop_time - Previous Unit of Work Completion Timestamp monitor element
- rows_read - Rows read monitor element
- rows_written - Rows Written monitor element
- sequence_no - Sequence number monitor element
- system_cpu_time - System CPU time monitor element
- tpmon_acc_str - TP monitor client accounting string monitor element
- tpmon_client_app - TP monitor client application name monitor element
- tpmon_client_userid - TP monitor client user ID monitor element
- tpmon_client_wkstn - TP monitor client workstation name monitor element
- uow_log_space_used - Unit of work log space used monitor element
- uow_start_time - Unit of work start timestamp monitor element
- uow_status - Unit of Work Status monitor element
- stop_time - Event Stop Time monitor element
- user_cpu_time - User CPU time monitor element
- x_lock_escals - Exclusive lock escalations monitor element
- evmon_flushes - Number of Event Monitor Flushes monitor element
evmonstart logical data group
lock logical data group
- partition_key - Partitioning key monitor element
- dl_conns - Connections involved in deadlock monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- member - Database member monitor element
- rolled_back_participant_no - Rolled back application participant monitor element
- deadlock_type - Deadlock type monitor element
lock_activity_values logical data group
- partition_key - Partitioning key monitor element
- activity_id - Activity ID monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- participant_no - Participant within Deadlock monitor element
- member - Database member monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_type - Value type monitor element
- uow_id - Unit of work ID monitor element
- stmt_value_data - Value data monitor element
- event_id - Event ID monitor element
lock_participant_activities logical data group
- partition_key - Partitioning key monitor element
- activity_id - Activity ID monitor element
- activity_type - Activity type monitor element
- consistency_token - Package consistency token monitor element
- effective_isolation - Effective isolation monitor element
- effective_query_degree - Effective query degree monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- incremental_bind - Incremental bind monitor element
- package_name - Package name monitor element
- package_schema - Package schema monitor element
- package_version_id - Package version monitor element
- participant_no - Participant within Deadlock monitor element
- member - Database member monitor element
- query_actual_degree - Actual runtime degree of intrapartition parallelism monitor element
- reopt - Reopt bind option monitor element
- section_number - Section number monitor element
- stmt_first_use_time - Statement first use timestamp monitor element
- stmt_invocation_id - Statement invocation identifier monitor element
- stmt_last_use_time - Statement last use timestamp monitor element
- stmt_lock_timeout - Statement lock timeout monitor element
- stmt_nest_level - Statement nesting level monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmt_query_id - Statement query identifier monitor element
- stmt_source_id - Statement source identifier monitor element
- stmt_type - Statement type monitor element
- uow_id - Unit of work ID monitor element
- stmt_text - SQL statement text monitor element
- stmt_unicode - Statement unicode flag monitor element
- stmt_operation/operation - Statement operation monitor element
lock_participants logical data group
- partition_key - Partitioning key monitor element
- agent_status - DCS Application Agents monitor element
- agent_id - Application handle (agent ID) monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- application_handle - Application handle monitor element
- auth_id - Authorization ID monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- coord_agent_tid - Coordinator agent engine dispatchable unit ID monitor element
- current_request - Current operation request monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- event_type - Event Type monitor element
- lock_attributes - Lock attributes monitor element
- lock_count - Lock count monitor element
- lock_current_mode - Original lock mode before conversion monitor element
- lock_escalation - Lock escalation monitor element
- lock_hold_count - Lock hold count monitor element
- lock_mode - Lock mode monitor element
- lock_mode_requested - Lock mode requested monitor element
- lock_name - Lock name monitor element
- lock_object_type - Lock object type waited on monitor element
- LOCK_OBJECT_TYPE_ID
- lock_release_flags - Lock release flags monitor element
- LOCK_RRIID
- lock_status - Lock status monitor element
- lock_timeout_val - Lock timeout value monitor element
- lock_wait_end_time - Lock wait end timestamp monitor element
- lock_wait_start_time - Lock wait start timestamp monitor element
- lock_wait_val - Lock wait value monitor element
- member - Database member monitor element
- object_requested - Requested object monitor element
- participant_no - Participant within Deadlock monitor element
- participant_no_holding_lk - Participant Holding a Lock on the Object Required by Application monitor element
- participant_type - Participant type monitor element
- past_activities_wrapped - Past activities list wrapped monitor element
- service_class_id - Service class ID monitor element
- service_subclass_name - Service subclass name monitor element
- table_file_id - Table file ID monitor element
- table_name - Table name monitor element
- table_schema - Table schema name monitor element
- thresholdid - Threshold ID monitor element
- threshold_name - Threshold name monitor element
- workload_id - Workload ID monitor element
- workload_name - Workload name monitor element
- agent_tid - Agent thread ID monitor element
- appl_action - Application action monitor element
- deadlock_member - Deadlock member monitor element
- queue_start_time - Queue start timestamp monitor element
- queued_agents - Queued threshold agents monitor element
- service_superclass_name - Service superclass name monitor element
- tablespace_name - Table space name monitor element
- xid - Transaction ID monitor element
- utility_invocation_id - Utility invocation ID monitor element
pkgcache logical data group
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- comp_env_desc - Compilation environment monitor element
- effective_isolation - Effective isolation monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- executable_id - Executable ID monitor element
- insert_timestamp - Insert timestamp monitor element
- last_metrics_update - Metrics last update timestamp monitor element
- member - Database member monitor element
- num_coord_exec - Number of executions by coordinator agent monitor element
- num_coord_exec_with_metrics - Number of executions by coordinator agent with metrics monitor element
- num_exec_with_metrics - Number of executions with metrics collected monitor element
- num_executions - Statement executions monitor element
- num_routines - Number of routines monitor element
- package_name - Package name monitor element
- package_schema - Package schema monitor element
- package_version_id - Package version monitor element
- member - Database member monitor element
- partition_key - Partitioning key monitor element
- planid - Query plan ID monitor element
- prep_time - Preparation time monitor element
- query_cost_estimate - Query cost estimate monitor element
- query_data_tag_list - Estimated query data tag list monitor element
- routine_id - Routine ID monitor element
- section_env - Section environment monitor element
- section_number - Section number monitor element
- section_type - Section type indicator monitor element
- semantic_env_id - Query semantic compilation environment ID monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- stmt_pkg_cache_id - Statement package cache identifier monitor element
- stmtid - Query statement ID monitor element
- stmt_type_id - Statement type identifier monitor element
- prep_warning_reason - Prepare warning SQLCODE reason identifier monitor element
- prep_warning - Prepare warning SQLCODE monitor element
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- stmt_text - SQL statement text monitor element
- stmtno - Statement number monitor element
- max_coord_stmt_exec_time - Maximum coordinator statement execution time monitor element
- max_coord_stmt_exec_timestamp - Maximum coordinator statement execution timestamp monitor element
pkgcache_metrics logical data group
- partition_key - Partitioning key monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- direct_read_time - Direct read time monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_write_time - Direct write time monitor element
- direct_write_reqs - Direct write requests monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_sort_time - Total section sort time monitor element
- total_act_time - Total activity time monitor element
- rows_read - Rows read monitor element
- rows_modified - Rows modified monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- total_cpu_time - Total CPU time monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- pool_index_writes - Buffer pool index writes monitor element
- direct_reads - Direct reads from database monitor element
- direct_writes - Direct writes to database monitor element
- rows_returned - Rows returned monitor element
- deadlocks - Deadlocks detected monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_escals - Number of lock escalations monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- sort_overflows - Sort overflows monitor element
- audit_events_total - Total audit events monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
- total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_sorts - Total sorts monitor element
- stmt_exec_time - Statement execution time monitor element
- coord_stmt_exec_time - Execution time for statement by coordinator agent monitor element
- total_routine_non_sect_proc_time - Non-section processing time monitor element
- total_routine_non_sect_time - Non-section routine execution time monitor elements
- total_section_proc_time - Total section processing time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_section_time - Total section time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- total_routine_time - Total routine time monitor element
- thresh_violations - Number of threshold violations monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- total_routine_invocations - Total routine invocations monitor elements
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits_global - Lock waits global monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_updated - Rows updated monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
pkgcache_stmt_args logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- stmt_value_index - Value index monitor element
- stmt_value_isreopt - Variable used for statement reoptimization monitor element
- stmt_value_isnull - Value has null value monitor element
- stmt_value_type - Value type monitor element
- stmt_value_data - Value data monitor element
- member - Database member monitor element
regvar logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- regvar_name - Registry variable name monitor element
- regvar_value - Registry variable value monitor element
- regvar_old_value - Registry variable old value monitor element
- regvar_level - Registry variable level monitor element
- regvar_collection_type - Registry variable collection type monitor element
sqlca logical data group
- sqlcabc
- sqlcaid
- sqlcode
- sqlerrd
- sqlerrmc
- sqlerrml
- sqlerrp
- sqlstate
- sqlwarn
txncompletion logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- global_transaction_id - Global transaction identifier monitor element
- local_transaction_id - Local transaction identifier monitor element
- savepoint_id - Savepoint ID monitor element
- uow_id - Unit of work ID monitor element
- ddl_classification - DDL classification monitor element
- txn_completion_status - Transaction completion status monitor element
uow logical data group
- active_col_vector_consumers_top - Active columnar vector memory consumers high watermark monitor element
- active_hash_grpbys_top - Active hash GROUP BY operations high watermark monitor element
- active_hash_joins_top - Active hash join operations high watermark monitor element
- active_olap_funcs_top - Active OLAP function operations high watermark monitor element
- active_peas_top - Active partial early aggregation operations high watermark monitor element
- active_peds_top - Active partial early distinct operations high watermark monitor element
- active_sort_consumers_top - Active sort memory consumers high watermark monitor element
- active_sorts_top - Active sorts high watermark monitor element
- application_handle - Application handle monitor element
- appl_id - Application ID monitor element
- appl_name - Application name monitor element
- client_acctng - Client accounting string monitor element
- client_applname - Client application name monitor element
- client_hostname - Client hostname monitor element
- client_pid - Client process ID monitor element
- client_port_number - Client port number monitor element
- client_prdid - Client product and version ID monitor element
- client_userid - Client user ID monitor element
- client_wrkstnname - Client workstation name monitor element
- completion_status - Completion status monitor element
- conn_time - Time of database connection monitor element
- coord_member - Coordinator member monitor element
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- executable_list_size - Size of executable list monitor element
- global_transaction_id - Global transaction identifier monitor element
- intra_parallel_state - Current state of intrapartition parallelism monitor element
- local_transaction_id - Local transaction identifier monitor element
- member - Database member monitor element
- db_conn_time - Database activation timestamp monitor element
- mon_interval_id - Monitor interval identifier monitor element
- package_list_exceeded - Package list exceeded monitor element
- package_list_size - Size of package list monitor element
- partition_key - Partitioning key monitor element
- service_class_id - Service class ID
- service_subclass_name - Service subclass name
- service_superclass_name - Service superclass name
- session_auth_id - Session authorization ID monitor element
- sort_consumer_heap_top - Individual private sort heap consumer high watermark monitor element
- sort_consumer_shrheap_top - Individual shared sort heap consumer high watermark monitor element
- sort_heap_top - Sort private heap high watermark monitor element
- sort_shrheap_top - Sort share heap high watermark monitor element
- start_time - Event start time
- stop_time - Event stop time
- system_auth_id - System authorization identifier monitor element
- UOW_CLIENT_PLATFORM
- UOW_CLIENT_PROTOCOL
- uow_id - Unit of work ID
- uow_log_space_used - Unit of work log space used monitor element
- workload_id - Workload ID
- workload_name - Workload name
- workload_occurrence_id - Workload occurrence identifier
- client_platform - Client operating platform monitor element
- client_protocol - Client communication protocol monitor element
- executable_list_truncated - Executable list truncated monitor element
- connection_start_time - Connection start time monitor element
uow_executable_list logical data group
- partition_key - Partitioning key monitor element
- appl_id - Application ID monitor element
- executable_id - Executable ID monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- num_executions - Statement executions monitor element
- member - Database member monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- rows_read - Rows read monitor element
- sort_overflows - Sort overflows monitor element
- total_act_time - Total activity time monitor element
- total_act_wait_time - Total activity wait time monitor element
- total_cpu_time - Total CPU time monitor element
- total_sorts - Total sorts monitor element
- uow_id - Unit of work ID
uow_metrics logical data group
- partition_key - Partitioning key monitor element
- appl_id - Application ID monitor element
- member - Database member monitor element
- uow_id - Unit of work ID monitor element
- wlm_queue_time_total - Workload manager total queue time monitor element
- wlm_queue_assignments_total - Workload manager total queue assignments monitor element
- fcm_tq_recv_wait_time - FCM table queue received wait time monitor element
- fcm_message_recv_wait_time - FCM message received wait time monitor element
- fcm_tq_send_wait_time - FCM table queue send wait time monitor element
- fcm_message_send_wait_time - FCM message send wait time monitor element
- agent_wait_time - Agent wait time monitor element
- agent_waits_total - Total agent waits monitor element
- lock_wait_time - Time waited on locks monitor element
- lock_waits - Lock waits monitor element
- direct_read_time - Direct read time monitor element
- direct_read_reqs - Direct read requests monitor element
- direct_write_time - Direct write time monitor element
- direct_write_reqs - Direct write requests monitor element
- log_buffer_wait_time - Log buffer wait time monitor element
- num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element
- log_disk_wait_time - Log disk wait time monitor element
- log_disk_waits_total - Total log disk waits monitor element
- tcpip_recv_wait_time - TCP/IP received wait time monitor element
- tcpip_recvs_total - TCP/IP receives total monitor element
- client_idle_wait_time - Client idle wait time monitor element
- ipc_recv_wait_time - Interprocess communication received wait time monitor element
- ipc_recvs_total - Interprocess communication receives total monitor element
- ipc_send_wait_time - Interprocess communication send wait time monitor element
- ipc_sends_total - Interprocess communication send total monitor element
- tcpip_send_wait_time - TCP/IP send wait time monitor element
- tcpip_sends_total - TCP/IP sends total monitor element
- pool_write_time - Total buffer pool physical write time monitor element
- pool_read_time - Total buffer pool physical read time monitor element
- audit_file_write_wait_time - Audit file write wait time monitor element
- audit_file_writes_total - Total audit files written monitor element
- audit_subsystem_wait_time - Audit subsystem wait time monitor element
- audit_subsystem_waits_total - Total audit subsystem waits monitor element
- diaglog_write_wait_time - Diagnostic log file write wait time monitor element
- diaglog_writes_total - Total diagnostic log file writes monitor element
- fcm_send_wait_time - FCM send wait time monitor element
- fcm_recv_wait_time - FCM received wait time monitor element
- total_wait_time - Total wait time monitor element
- rqsts_completed_total - Total requests completed monitor element
- total_rqst_time - Total request time monitor element
- app_rqsts_completed_total - Total application requests completed monitor element
- total_app_rqst_time - Total application request time monitor element
- total_section_sort_proc_time - Total section sort processing time monitor element
- total_section_sorts - Total section sorts monitor element
- total_section_sort_time - Total section sort time monitor element
- rows_read - Rows read monitor element
- rows_modified - Rows modified monitor element
- pool_data_l_reads - Buffer pool data logical reads monitor element
- pool_index_l_reads - Buffer pool index logical reads monitor element
- pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element
- pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element
- pool_xda_l_reads - Buffer pool XDA data logical reads monitor element
- pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element
- total_cpu_time - Total CPU time monitor element
- act_completed_total - Total completed activities monitor element
- pool_data_p_reads - Buffer pool data physical reads monitor element
- pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element
- pool_xda_p_reads - Buffer pool XDA data physical reads monitor element
- pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element
- pool_index_p_reads - Buffer pool index physical reads monitor element
- pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element
- pool_data_writes - Buffer pool data writes monitor element
- pool_xda_writes - Buffer pool XDA data writes monitor element
- pool_index_writes - Buffer pool index writes monitor element
- direct_reads - Direct reads from database monitor element
- direct_writes - Direct writes to database monitor element
- rows_returned - Rows returned monitor element
- deadlocks - Deadlocks detected monitor element
- lock_timeouts - Number of lock timeouts monitor element
- lock_escals - Number of lock escalations monitor element
- fcm_sends_total - FCM sends total monitor element
- fcm_recvs_total - FCM receives total monitor element
- fcm_send_volume - FCM send volume monitor element
- fcm_recv_volume - FCM received volume monitor element
- fcm_message_sends_total - Total FCM message sends monitor element
- fcm_message_recvs_total - Total FCM message receives monitor element
- fcm_message_send_volume - FCM message send volume monitor element
- fcm_message_recv_volume - FCM message received volume monitor element
- fcm_tq_sends_total - FCM table queue send total monitor element
- fcm_tq_recvs_total - FCM table queue receives total monitor element
- fcm_tq_send_volume - FCM table queue send volume monitor element
- fcm_tq_recv_volume - FCM table queue received volume monitor element
- tq_tot_send_spills - Total number of table queue buffers overflowed monitor element
- tcpip_send_volume - TCP/IP send volume monitor element
- tcpip_recv_volume - TCP/IP received volume monitor element
- ipc_send_volume - Interprocess communication send volume monitor element
- ipc_recv_volume - Interprocess communication received volume monitor element
- post_threshold_sorts - Post threshold sorts monitor element
- post_shrthreshold_sorts - Post shared threshold sorts monitor element
- sort_overflows - Sort overflows monitor element
- audit_events_total - Total audit events monitor element
- act_rejected_total - Total rejected activities monitor element
- act_aborted_total - Total aborted activities monitor element
- total_backup_proc_time - Total non-wait time for online backups monitor element
- total_backup_time - Total elapsed time for doing online backups monitor element
- total_backups - Total online backups monitor element
- total_col_vector_consumers - Total columnar vector memory consumers monitor element
- total_index_build_proc_time - Total non-wait time spent building indexes due to index creation or re-creation monitor element
- total_index_build_time - Total time spent building indexes due to index creation or re-creation monitor element
- total_indexes_built - Total number of indexes built monitor element
- total_sorts - Total sorts monitor element
- total_routine_time - Total routine time monitor element
- total_compile_proc_time - Total compile processing time monitor element
- total_compilations - Total compilations monitor element
- total_compile_time - Total compile time monitor element
- total_implicit_compile_proc_time - Total implicit compile processing time monitor element
- total_implicit_compilations - Total implicit compilations monitor element
- total_implicit_compile_time - Total implicit compile time monitor element
- total_runstats_proc_time - Total runtime statistics processing time monitor element
- total_runstats - Total runtime statistics monitor element
- total_runstats_time - Total runtime statistics time monitor element
- total_reorg_proc_time - Total reorganization processing time monitor element
- total_reorgs - Total reorganizations monitor element
- total_reorg_time - Total reorganization time monitor element
- total_load_proc_time - Total load processing time monitor element
- total_loads - Total loads monitor element
- total_load_time - Total load time monitor element
- total_section_proc_time - Total section processing time monitor element
- total_app_section_executions - Total application section executions monitor element
- total_section_time - Total section time monitor element
- total_commit_proc_time - Total commits processing time monitor element
- total_app_commits - Total application commits monitor elements
- total_commit_time - Total commit time monitor element
- total_rollback_proc_time - Total rollback processing time monitor element
- total_app_rollbacks - Total application rollbacks monitor element
- total_rollback_time - Total rollback time monitor element
- total_routine_user_code_proc_time - Total routine user code processing time monitor element
- total_routine_user_code_time - Total routine user code time monitor element
- thresh_violations - Number of threshold violations monitor element
- num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element
- total_routine_invocations - Total routine invocations monitor elements
- int_commits - Internal commits monitor element
- int_rollbacks - Internal rollbacks monitor element
- cat_cache_inserts - Catalog cache inserts monitor element
- cat_cache_lookups - Catalog cache lookups monitor element
- pkg_cache_inserts - Package cache inserts monitor element
- pkg_cache_lookups - Package cache lookups monitor element
- act_rqsts_total - Total activity requests monitor elements
- total_act_wait_time - Total activity wait time monitor element
- total_act_time - Total activity time monitor element
- lock_wait_time_global - Lock wait time global monitor element
- lock_waits_global - Lock waits global monitor element
- reclaim_wait_time - Reclaim wait time monitor element
- spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor element
- lock_timeouts_global - Lock timeouts global monitor element
- lock_escals_maxlocks - Number of maxlocks lock escalations monitor element
- lock_escals_locklist - Number of locklist lock escalations monitor element
- lock_escals_global - Number of global lock escalations monitor element
- cf_wait_time - cluster caching facility wait time monitor element
- cf_waits - Number of cluster caching facility waits monitor element
- pool_data_gbp_l_reads - Group buffer pool data logical reads monitor element
- pool_data_gbp_p_reads - Group buffer pool data physical reads monitor element
- pool_data_lbp_pages_found - Local buffer pool found data pages monitor element
- pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor element
- pool_index_gbp_l_reads - Group buffer pool index logical reads monitor element
- pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elements
- pool_index_lbp_pages_found - Local buffer pool index pages found monitor element
- pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor element
- pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor element
- pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor element
- pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor element
- pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor element
- evmon_wait_time - Event monitor wait time monitor element
- evmon_waits_total - Event monitor total waits monitor element
- total_extended_latch_wait_time - Total extended latch wait time monitor element
- total_extended_latch_waits - Total extended latch waits monitor element
- total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor element
- total_stats_fabrications - Total statistics fabrications monitor elements
- total_stats_fabrication_time - Total statistics fabrication time monitor element
- total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor element
- total_sync_runstats - Total synchronous RUNSTATS activities monitor element
- total_sync_runstats_time - Total synchronous RUNSTATS time monitor elements
- total_disp_run_queue_time - Total dispatcher run queue time monitor element
- pool_queued_async_data_reqs - Data prefetch requests monitor element
- pool_queued_async_index_reqs - Index prefetch requests monitor element
- pool_queued_async_xda_reqs - XDA prefetch requests monitor element
- pool_queued_async_data_pages - Data pages prefetch requests monitor element
- pool_queued_async_index_pages - Index pages prefetch requests monitor element
- pool_queued_async_xda_pages - XDA pages prefetch requests monitor element
- app_act_completed_total - Total successful external coordinator activities monitor element
- app_act_aborted_total - Total failed external coordinator activities monitor element
- app_act_rejected_total - Total rejected external coordinator activities monitor element
- dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor element
- static_sql_stmts - Static SQL Statements Attempted monitor element
- failed_sql_stmts - Failed Statement Operations monitor element
- select_sql_stmts - Select SQL Statements Executed monitor element
- uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor element
- ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor element
- merge_sql_stmts - Merge SQL statements executed monitor element
- call_sql_stmts - CALL SQL statements executed monitor element
- xquery_stmts - XQuery Statements Attempted monitor element
- rows_deleted - Rows deleted monitor element
- rows_inserted - Rows inserted monitor element
- rows_updated - Rows updated monitor element
- int_rows_deleted - Internal Rows Deleted monitor element
- int_rows_inserted - Internal Rows Inserted monitor element
- int_rows_updated - Internal Rows Updated monitor element
- implicit_rebinds - number of implicit rebinds monitor element
- binds_precompiles - Binds/Precompiles Attempted monitor element
- total_hash_joins - Total Hash Joins monitor element
- total_hash_loops - Total Hash Loops monitor element
- hash_join_overflows - Hash Join Overflows monitor element
- hash_join_small_overflows - Hash Join Small Overflows monitor element
- post_shrthreshold_hash_joins - Post threshold hash joins monitor element
- post_threshold_col_vector_consumers - Post-threshold columnar vector memory consumers monitor element
- post_threshold_hash_joins - Hash Join Threshold monitor element
- total_olap_funcs - Total OLAP Functions monitor element
- olap_func_overflows - OLAP Function Overflows monitor element
uow_package_list logical data group
- partition_key - Partitioning key monitor element
- appl_id - Application ID monitor element
- invocation_id - Invocation ID monitor element
- nesting_level - Nesting level monitor element
- package_elapsed_time - Package elapsed time monitor element
- package_id - Package identifier monitor element
- routine_id - Routine ID monitor element
- uow_id - Unit of work ID monitor element
- member - Database member monitor element
utillocation logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
- device_type - Device type monitor element
- location_type - Location type monitor element
- location - Location monitor element
utilphase logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
- utility_phase_type - Utility phase type monitor element
- phase_start_event_id - Phase start event ID monitor element
- phase_start_event_timestamp - Phase start event timestamp monitor element
- objtype - Object type monitor element
- object_schema - Object schema monitor element
- object_name - Object name monitor element
- utility_phase_detail - Utility phase detail monitor element
utilstart logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
- utility_operation_type - Utility operation type monitor element
- utility_invoker_type - Utility Invoker Type monitor element
- utility_priority - Utility Priority monitor element
- utility_start_type - Utility start type monitor element
- objtype - Object type monitor element
- object_schema - Object schema monitor element
- object_name - Object name monitor element
- num_tbsps - Number of table spaces monitor element
- tbsp_names - Table space names monitor element
- utility_detail - Utility detail monitor element
utilstop logical data group
- event_id - Event ID monitor element
- event_timestamp - Event timestamp monitor element
- member - Database member monitor element
- event_type - Event Type monitor element
- utility_invocation_id - Utility invocation ID monitor element
- utility_type - Utility Type monitor element
- utility_stop_type - Utility stop type monitor element
- start_event_id - Start event ID monitor element
- start_event_timestamp - Start event timestamp monitor element
- sqlca - SQL Communications Area (SQLCA) monitor element