DB2 Version 9.7 for Linux, UNIX, and Windows

Information written to XML for system_metrics and activity_metrics monitor elements

The activity_metrics monitor element is reported in the MON_GET_ACTIVITY_DETAILS table function, the MON_GET_PKG_CACHE_STMT_DETAILS table function, and the activity event monitor. The system_metrics monitor element is reported in the MON_GET_CONNECTION_DETAILS, MON_GET_UNIT_OF_WORK_DETAILS, MON_GET_SERVICE_SUBCLASS_DETAILS, MON_GET_WORKLOAD_DETAILS table functions, and the statistics event monitor. This is also documented in the sqllib/misc/DB2MonCommon.xsd file.

system_metrics

System level metrics.

Element content: ( wlm_queue_time_total , wlm_queue_assignments_total , fcm_tq_recv_wait_time , fcm_message_recv_wait_time , fcm_tq_send_wait_time , fcm_message_send_wait_time , agent_wait_time , agent_waits_total , lock_wait_time , lock_waits , direct_read_time , direct_read_reqs , direct_write_time , direct_write_reqs , log_buffer_wait_time , num_log_buffer_full , log_disk_wait_time , log_disk_waits_total , tcpip_recv_wait_time , tcpip_recvs_total , client_idle_wait_time , ipc_recv_wait_time , ipc_recvs_total , ipc_send_wait_time , ipc_sends_total , tcpip_send_wait_time , tcpip_sends_total , pool_write_time , pool_read_time , audit_file_write_wait_time , audit_file_writes_total , audit_subsystem_wait_time , audit_subsystem_waits_total , diaglog_write_wait_time , diaglog_writes_total , fcm_send_wait_time , fcm_recv_wait_time , total_wait_time , total_rqst_time , rqsts_completed_total , total_app_rqst_time , app_rqsts_completed_total , total_section_sort_proc_time , total_section_sort_time , total_section_sorts , rows_read , rows_modified , pool_data_l_reads , pool_index_l_reads , pool_temp_data_l_reads , pool_temp_index_l_reads , pool_xda_l_reads , pool_temp_xda_l_reads , total_cpu_time , act_completed_total , pool_data_p_reads , pool_temp_data_p_reads , pool_xda_p_reads , pool_temp_xda_p_reads , pool_index_p_reads , pool_temp_index_p_reads , pool_data_writes , pool_xda_writes , pool_index_writes , direct_reads , direct_writes , rows_returned , deadlocks , lock_timeouts , lock_escals , fcm_sends_total , fcm_recvs_total , fcm_send_volume , fcm_recv_volume , fcm_message_sends_total , fcm_message_recvs_total , fcm_message_send_volume , fcm_message_recv_volume , fcm_tq_sends_total , fcm_tq_recvs_total , fcm_tq_send_volume , fcm_tq_recv_volume , tq_tot_send_spills , tcpip_send_volume , tcpip_recv_volume , ipc_send_volume , ipc_recv_volume , post_threshold_sorts , post_shrthreshold_sorts , sort_overflows , audit_events_total , total_rqst_mapped_in {zero or one times (?)}, total_rqst_mapped_out {zero or one times (?)} , act_rejected_total, act_aborted_total , total_sorts , total_routine_time , total_compile_proc_time , total_compile_time , total_compilations , total_implicit_compile_proc_time , total_implicit_compile_time , total_implicit_compilations , total_runstats_proc_time , total_runstats_time , total_runstats , total_reorg_proc_time , total_reorg_time , total_reorgs , total_load_proc_time , total_load_time , total_loads , total_section_proc_time , total_section_time , total_app_section_executions , total_commit_proc_time , total_commit_time , total_app_commits , total_rollback_proc_time , total_rollback_time , total_app_rollbacks , total_routine_user_code_proc_time , total_routine_user_code_time , thresh_violations , num_lw_thresh_exceeded , total_routine_invocations , int_commits , int_rollbacks , cat_cache_inserts , cat_cache_lookups , pkg_cache_inserts , pkg_cache_lookups , act_rqsts_total , total_act_wait_time , total_act_time , ANY content ( skip ) {zero or more (*)} )

Attributes:

QName Type Fixed Default Use Annotation
release xs:long required  
ANY attribute from ANY namespace          

activity_metrics

Activity level metrics.

Element content: ( wlm_queue_time_total , wlm_queue_assignments_total , fcm_tq_recv_wait_time , fcm_message_recv_wait_time , fcm_tq_send_wait_time , fcm_message_send_wait_time , lock_wait_time , lock_waits , direct_read_time , direct_read_reqs , direct_write_time , direct_write_reqs , log_buffer_wait_time , num_log_buffer_full , log_disk_wait_time , log_disk_waits_total , pool_write_time , pool_read_time , audit_file_write_wait_time , audit_file_writes_total , audit_subsystem_wait_time , audit_subsystem_waits_total , diaglog_write_wait_time , diaglog_writes_total , fcm_send_wait_time , fcm_recv_wait_time , total_act_wait_time , total_section_sort_proc_time , total_section_sort_time , total_section_sorts , total_act_time , rows_read , rows_modified , pool_data_l_reads , pool_index_l_reads , pool_temp_data_l_reads , pool_temp_index_l_reads , pool_xda_l_reads , pool_temp_xda_l_reads , total_cpu_time , pool_data_p_reads , pool_temp_data_p_reads , pool_xda_p_reads , pool_temp_xda_p_reads , pool_index_p_reads , pool_temp_index_p_reads , pool_data_writes , pool_xda_writes , pool_index_writes , direct_reads , direct_writes , rows_returned , deadlocks , lock_timeouts , lock_escals , fcm_sends_total , fcm_recvs_total , fcm_send_volume , fcm_recv_volume , fcm_message_sends_total , fcm_message_recvs_total , fcm_message_send_volume , fcm_message_recv_volume , fcm_tq_sends_total , fcm_tq_recvs_total , fcm_tq_send_volume , fcm_tq_recv_volume , tq_tot_send_spills , post_threshold_sorts , post_shrthreshold_sorts , sort_overflows , audit_events_total , total_sorts , stmt_exec_time , coord_stmt_exec_time {zero or one times (?)} , total_routine_non_sect_proc_time , total_routine_non_sect_time , total_section_proc_time , total_section_time , total_app_section_executions , total_routine_user_code_proc_time , total_routine_user_code_time , total_routine_time , thresh_violations , num_lw_thresh_exceeded , total_routine_invocations , ANY content ( skip ) {zero or more (*)} )

Attributes:

QName Type Fixed Default Use Annotation
release xs:long required  
ANY attribute from ANY namespace          

agent_wait_time

See monitor element agent_wait_time - Agent wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

agent_waits_total

See monitor element agent_waits_total - Total agent waits monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

tcpip_recv_wait_time

See monitor element tcpip_recv_wait_time - TCP/IP received wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

tcpip_recvs_total

See monitor element tcpip_recvs_total - TCP/IP receives total monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

client_idle_wait_time

See monitor element client_idle_wait_time - Client idle wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ipc_recv_wait_time

See monitor element ipc_recv_wait_time - Interprocess communication received wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ipc_recvs_total

See monitor element ipc_recvs_total - Interprocess communication receives total monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ipc_send_wait_time

See monitor element ipc_send_wait_time - Interprocess communication send wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ipc_sends_total

See monitor element ipc_sends_total - Interprocess communication send total monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

tcpip_send_wait_time

See monitor element tcpip_send_wait_time - TCP/IP send wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

tcpip_sends_total

See monitor element tcpip_sends_total - TCP/IP sends total monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_wait_time

See monitor element total_wait_time - Total wait time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_rqst_time

See monitor element total_rqst_time - Total request time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

rqsts_completed_total

See monitor element rqsts_completed_total - Total requests completed monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_app_rqst_time

See monitor element total_app_rqst_time - Total application request time monitor element for more details.

Contained by:system_metrics

Element content:
Type Facet
xs:long  

app_rqsts_completed_total

See monitor element app_rqsts_completed_total - Total application requests completed monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

act_completed_total

See monitor element act_completed_total - Total completed activities monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

tcpip_send_volume

See monitor element tcpip_send_volume - TCP/IP send volume monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

tcpip_recv_volume

See monitor element tcpip_recv_volume - TCP/IP received volume monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ipc_send_volume

See monitor element ipc_send_volume - Interprocess communication send volume monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ipc_recv_volume

See monitor element ipc_recv_volume - Interprocess communication received volume monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_rqst_mapped_in

See monitor element total_rqst_mapped_in - Total request mapped-in monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_rqst_mapped_out

See monitor element total_rqst_mapped_out - Total request mapped-out monitor element for more details.

Contained by:system_metrics

Element content:
Type Facet
xs:long  

act_rejected_total

See monitor element act_rejected_total - Total rejected activities monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

act_aborted_total

See monitor element act_aborted_total - Total aborted activities monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_compile_proc_time

See monitor element total_compile_proc_time - Total compile processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_compile_time

See monitor element total_compile_time - Total compile time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_compilations

See monitor element total_compilations - Total compilations monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_implicit_compile_proc_time

See monitor element total_implicit_compile_proc_time - Total implicit compile processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_implicit_compile_time

See monitor element total_implicit_compile_time - Total implicit compile time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_implicit_compilations

See monitor element total_implicit_compilations - Total implicit complications monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_runstats_proc_time

See monitor element total_runstats_proc_time - Total runtime statistics processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_runstats_time

See monitor element total_runstats_time - Total runtime statistics time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_runstats

See monitor element total_runstats - Total runtime statistics monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_reorg_proc_time

See monitor element total_reorg_proc_time - Total reorganization processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_reorg_time

See monitor element total_reorg_time - Total reorganization time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_reorgs

See monitor element total_reorgs - Total reorganizations monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_load_proc_time

See monitor element total_load_proc_time - Total load processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_load_time

See monitor element total_load_time - Total load time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_loads

See monitor element total_loads - Total loads monitor element for more details.

Contained by:system_metrics

Element content:
Type Facet
xs:long  

total_commit_proc_time

See monitor element total_commit_proc_time - Total commits processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_commit_time

See monitor element total_commit_time - Total commit time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_app_commits

See monitor element total_app_commits - Total application commits monitor elements for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_rollback_proc_time

See monitor element total_rollback_proc_time - Total rollback processing time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_rollback_time

See monitor element total_rollback_time - Total rollback time monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_app_rollbacks

See monitor element total_app_rollbacks - Total application rollbacks monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

int_commits

See monitor element int_commits - Internal commits monitor element for more details.

Contained by:system_metrics

Element content:
Type Facet
xs:long  

int_rollbacks

See monitor element int_rollbacks - Internal rollbacks monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

cat_cache_inserts

See monitor element cat_cache_inserts - Catalog cache inserts monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

cat_cache_lookups

See monitor element cat_cache_lookups - Catalog cache lookups monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

pkg_cache_inserts

See monitor element pkg_cache_inserts - Package cache inserts monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

pkg_cache_lookups

See monitor element pkg_cache_lookups - Package cache lookups monitor element for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

act_rqsts_total

See monitor element act_rqsts_total - Total activity requests monitor elements for more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

wlm_queue_time_total

See monitor element wlm_queue_time_total - Workload manager total queue time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

wlm_queue_assignments_total

See monitor element wlm_queue_assignments_total - Workload manager total queue assignments monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_recv_wait_time

See monitor element fcm_tq_recv_wait_time - FCM table queue received wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_recv_wait_time

See monitor element fcm_message_recv_wait_time - FCM message received wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_send_wait_time

See monitor element fcm_tq_send_wait_time - FCM table queue send wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_send_wait_time

See monitor element fcm_message_send_wait_time - FCM message send wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_wait_time

See monitor element lock_wait_time - Time waited on locks monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_waits

See monitor element lock_waits - Lock waits monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

direct_read_time

See monitor element direct_read_time - Direct read time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

direct_read_reqs

See monitor element direct_read_reqs - Direct read requests monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

direct_write_time

See monitor element direct_write_time - Direct write time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

direct_write_reqs

See monitor element direct_write_reqs - Direct write requests monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

log_buffer_wait_time

See monitor element log_buffer_wait_time - Log buffer wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

num_log_buffer_full

See monitor element num_log_buffer_full - Number of times full log buffer caused agents to wait monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

log_disk_wait_time

See monitor element log_disk_wait_time - Log disk wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

log_disk_waits_total

See monitor element log_disk_waits_total - Total log disk waits monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_write_time

See monitor element pool_write_time - Total buffer pool physical write time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_read_time

See monitor element pool_read_time - Total buffer pool physical read time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

audit_file_write_wait_time

See monitor element audit_file_write_wait_time - Audit file write wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

audit_file_writes_total

See monitor element audit_file_writes_total - Total audit files written monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

audit_subsystem_wait_time

See monitor element audit_subsystem_wait_time - Audit subsystem wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

audit_subsystem_waits_total

See monitor element audit_subsystem_waits_total - Total audit subsystem waits monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

diaglog_write_wait_time

See monitor element diaglog_write_wait_time - Diagnostic log file write wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

diaglog_writes_total

See monitor element diaglog_writes_total - Total diagnostic log file writes monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_send_wait_time

See monitor element fcm_send_wait_time - FCM send wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_recv_wait_time

See monitor element fcm_recv_wait_time - FCM received wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_act_wait_time

See monitor element total_act_wait_time - Total activity wait time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_section_sort_proc_time

See monitor element total_section_sort_proc_time - Total section sort processing time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_section_sort_time

See monitor element total_section_sort_time - Total section sort time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_section_sorts

See monitor element total_section_sorts - Total section sorts monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_act_time

See monitor element total_act_time - Total activity time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_read

See monitor element rows_read - Rows read monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_modified

See monitor element rows_modified - Rows modified monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_l_reads

See monitor element pool_data_l_reads - Buffer pool data logical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_l_reads

See monitor element pool_index_l_reads - Buffer pool index logical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_data_l_reads

See monitor element pool_temp_data_l_reads - Buffer pool temporary data logical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_index_l_reads

See monitor element pool_temp_index_l_reads - Buffer pool temporary index logical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_l_reads

See monitor element pool_xda_l_reads - Buffer pool XDA data logical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_xda_l_reads

See monitor element pool_temp_xda_l_reads - Buffer pool temporary XDA data logical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_cpu_time

See monitor element total_cpu_time - Total CPU time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_p_reads

See monitor element pool_data_p_reads - Buffer pool data physical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_data_p_reads

See monitor element pool_temp_data_p_reads - Buffer pool temporary data physical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_p_reads

See monitor element pool_xda_p_reads - Buffer pool XDA data physical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_xda_p_reads

See monitor element pool_temp_xda_p_reads - Buffer pool temporary XDA data physical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_p_reads

See monitor element pool_index_p_reads - Buffer pool index physical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_index_p_reads

See monitor element pool_temp_index_p_reads - Buffer pool temporary index physical reads monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_writes

See monitor element pool_data_writes - Buffer pool data writes monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_writes

See monitor element pool_xda_writes - Buffer pool XDA data writes monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_writes

See monitor element pool_index_writes - Buffer pool index writes monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

direct_reads

See monitor element direct_reads - Direct reads from database monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

direct_writes

See monitor element direct_writes - Direct writes to database monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_returned

See monitor element rows_returned - Rows returned monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

deadlocks

See monitor element deadlocks - Deadlocks detected monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_timeouts

See monitor element lock_timeouts - Number of lock timeouts monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_escals

See monitor element lock_escals - Number of lock escalations monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_sends_total

See monitor element fcm_sends_total - FCM sends total monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_recvs_total

See monitor element fcm_recvs_total - FCM receives total monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_send_volume

See monitor element fcm_send_volume - FCM send volume monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_recv_volume

See monitor element fcm_recv_volume - FCM received volume monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_sends_total

See monitor element fcm_message_sends_total - Total FCM message sends monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_recvs_total

See monitor element fcm_message_recvs_total - Total FCM message receives monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_send_volume

See monitor element fcm_message_send_volume - FCM message send volume monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_recv_volume

See monitor element fcm_message_recv_volume - FCM message received volume monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_sends_total

See monitor element fcm_tq_sends_total - FCM table queue send total monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_recvs_total

See monitor element fcm_tq_recvs_total - FCM table queue receives total monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_send_volume

See monitor element fcm_tq_send_volume - FCM table queue send volume monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_recv_volume

See monitor element fcm_tq_recv_volume - FCM table queue received volume monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

tq_tot_send_spills

See monitor element tq_tot_send_spills - Total number of table queue buffers overflowed monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_threshold_sorts

See monitor element post_threshold_sorts - Post threshold sorts monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_shrthreshold_sorts

See monitor element post_shrthreshold_sorts - Post shared threshold sorts monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

sort_overflows

See monitor element sort_overflows - Sort overflows monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

audit_events_total

See monitor element audit_events_total - Total audit events monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_sorts

See monitor element total_sorts - Total sorts monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

stmt_exec_time

See monitor element stmt_exec_time - Statement execution time monitor element for more details.

Contained by: activity_metrics

Element content:
Type Facet
xs:long  

coord_stmt_exec_time

See monitor element coord_stmt_exec_time - Execution time for statement by coordinator agent monitor element for more details.

Contained by: activity_metrics

Element content:
Type Facet
xs:long  

total_routine_non_sect_proc_time

See monitor element total_routine_non_sect_proc_time - Non-section processing time monitor element for more details.

Contained by: activity_metrics

Element content:
Type Facet
xs:long  

total_routine_non_sect_time

See monitor element total_routine_non_sect_time - Non-section routine execution time monitor elements for more details.

Contained by: activity_metrics

Element content:
Type Facet
xs:long  

total_section_proc_time

See monitor element total_section_proc_time - Total section processing time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_section_time

See monitor element total_section_time - Total section time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_app_section_executions

See monitor element total_app_section_executions - Total application section executions monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_routine_user_code_proc_time

See monitor element total_routine_user_code_proc_time - Total routine user code processing time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_routine_user_code_time

See monitor element total_routine_user_code_time - Total routine user code time monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_routine_time

See monitor element total_routine_time - Total routine time monitor element for more details.

Contained by: system_metricsactivity_metrics

Element content:
Type Facet
xs:long  

thresh_violations

See monitor element thresh_violations - Number of threshold violations monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

num_lw_thresh_exceeded

See monitor element num_lw_thresh_exceeded - Number of lock wait thresholds exceeded monitor element for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_routine_invocations

See monitor element total_routine_invocations - Total routine invocations monitor elements for more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long