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 {zero or one times (?)} , agent_waits_total {zero or one times (?)} , 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 {zero or one times (?)} , tcpip_recvs_total {zero or one times (?)} , client_idle_wait_time {zero or one times (?)} , ipc_recv_wait_time {zero or one times (?)} , ipc_recvs_total {zero or one times (?)} , ipc_send_wait_time {zero or one times (?)} , ipc_sends_total {zero or one times (?)} , tcpip_send_wait_time {zero or one times (?)} , tcpip_sends_total {zero or one times (?)} , 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 {zero or one times (?)} , tcpip_recv_volume {zero or one times (?)} , ipc_send_volume {zero or one times (?)} , ipc_recv_volume {zero or one times (?)} , 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 , lock_wait_time_global , lock_waits_global , reclaim_wait_time , spacemappage_reclaim_wait_time , lock_timeouts_global , lock_escals_maxlocks , lock_escals_locklist , lock_escals_global , cf_wait_time , cf_waits , pool_data_gbp_l_reads , pool_data_gbp_p_reads , pool_data_lbp_pages_found , pool_data_gbp_invalid_pages , pool_index_gbp_l_reads , pool_index_gbp_p_reads , pool_index_lbp_pages_found , pool_index_gbp_invalid_pages , pool_xda_gbp_l_reads , pool_xda_gbp_p_reads , pool_xda_lbp_pages_found , pool_xda_gbp_invalid_pages , evmon_wait_time , evmon_waits_total , total_extended_latch_wait_time , total_extended_latch_waits , total_stats_fabrication_proc_time , total_stats_fabrication_time , total_stats_fabrications , total_sync_runstats_proc_time , total_sync_runstats_time , total_sync_runstats , total_disp_run_queue_time , pool_queued_async_data_reqs , pool_queued_async_index_reqs , pool_queued_async_xda_reqs , pool_queued_async_temp_data_reqs , pool_queued_async_temp_index_reqs , pool_queued_async_temp_xda_reqs , pool_queued_async_other_reqs , pool_queued_async_data_pages , pool_queued_async_index_pages , pool_queued_async_xda_pages , pool_queued_async_temp_data_pages , pool_queued_async_temp_index_pages , pool_queued_async_temp_xda_pages , pool_failed_async_data_reqs , pool_failed_async_index_reqs , pool_failed_async_xda_reqs , pool_failed_async_temp_data_reqs , pool_failed_async_temp_index_reqs , pool_failed_async_temp_xda_reqs , pool_failed_async_other_reqs , app_act_completed_total {zero or one times (?)} , app_act_aborted_total {zero or one times (?)} , app_act_rejected_total {zero or one times (?)} , total_peds , disabled_peds , post_threshold_peds , total_peas , post_threshold_peas , tq_sort_heap_requests , tq_sort_heap_rejections , total_connect_request_proc_time {zero or one times (?)} , total_connect_request_time {zero or one times (?)} , total_connect_requests {zero or one times (?)} , total_connect_authentication_proc_time {zero or one times (?)} , total_connect_authentication_time {zero or one times (?)} , total_connect_authentications {zero or one times (?)} , prefetch_wait_time , prefetch_waits , pool_data_gbp_indep_pages_found_in_lbp , pool_index_gbp_indep_pages_found_in_lbp , pool_xda_gbp_indep_pages_found_in_lbp , comm_exit_wait_time , comm_exit_waits , uow_client_idle_wait_time {zero or one times (?)} , 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 , ida_sends_total , ida_send_volume , ida_recv_wait_time , ida_recvs_total , ida_recv_volume , rows_deleted , rows_inserted , rows_updated , total_hash_joins , total_hash_loops , hash_join_overflows , hash_join_small_overflows , post_shrthreshold_hash_joins , total_olap_funcs , olap_func_overflows , dynamic_sql_stmts , static_sql_stmts , failed_sql_stmts , select_sql_stmts , uid_sql_stmts , ddl_sql_stmts , merge_sql_stmts , xquery_stmts , implicit_rebinds , binds_precompiles , int_rows_deleted , int_rows_inserted , int_rows_updated , call_sql_stmts , pool_col_l_reads , pool_temp_col_l_reads , pool_col_p_reads , pool_temp_col_p_reads , pool_col_lbp_pages_found , pool_col_writes , pool_col_gbp_l_reads , pool_col_gbp_p_reads , pool_col_gbp_invalid_pages , pool_col_gbp_indep_pages_found_in_lbp , pool_queued_async_col_reqs , pool_queued_async_temp_col_reqs , pool_queued_async_col_pages , pool_queued_async_temp_col_pages , pool_failed_async_col_reqs , pool_failed_async_temp_col_reqs , total_col_proc_time , total_col_time , total_col_executions , post_threshold_hash_joins , pool_caching_tier_page_read_time , pool_caching_tier_page_write_time , pool_data_caching_tier_l_reads , pool_index_caching_tier_l_reads , pool_xda_caching_tier_l_reads , pool_col_caching_tier_l_reads , pool_data_caching_tier_page_writes , pool_index_caching_tier_page_writes , pool_xda_caching_tier_page_writes , pool_col_caching_tier_page_writes , pool_data_caching_tier_page_updates , pool_index_caching_tier_page_updates , pool_xda_caching_tier_page_updates , pool_col_caching_tier_page_updates , pool_data_caching_tier_pages_found , pool_index_caching_tier_pages_found , pool_xda_caching_tier_pages_found , pool_col_caching_tier_pages_found , pool_data_caching_tier_gbp_invalid_pages , pool_index_caching_tier_gbp_invalid_pages , pool_xda_caching_tier_gbp_invalid_pages , pool_col_caching_tier_gbp_invalid_pages , pool_data_caching_tier_gbp_indep_pages_found , pool_index_caching_tier_gbp_indep_pages_found , pool_xda_caching_tier_gbp_indep_pages_found , pool_col_caching_tier_gbp_indep_pages_found , total_hash_grpbys , hash_grpby_overflows , post_threshold_hash_grpbys , post_threshold_olap_funcs , 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 , lock_wait_time_global , lock_waits_global , reclaim_wait_time , spacemappage_reclaim_wait_time , lock_timeouts_global , lock_escals_maxlocks , lock_escals_locklist , lock_escals_global , cf_wait_time , cf_waits , pool_data_gbp_l_reads , pool_data_gbp_p_reads , pool_data_lbp_pages_found , pool_data_gbp_invalid_pages , pool_index_gbp_l_reads , pool_index_gbp_p_reads , pool_index_lbp_pages_found , pool_index_gbp_invalid_pages , pool_xda_gbp_l_reads , pool_xda_gbp_p_reads , pool_xda_lbp_pages_found , pool_xda_gbp_invalid_pages , evmon_wait_time , evmon_waits_total , total_extended_latch_wait_time , total_extended_latch_waits , total_disp_run_queue_time , pool_queued_async_data_reqs , pool_queued_async_index_reqs , pool_queued_async_xda_reqs , pool_queued_async_temp_data_reqs , pool_queued_async_temp_index_reqs , pool_queued_async_temp_xda_reqs , pool_queued_async_other_reqs , pool_queued_async_data_pages , pool_queued_async_index_pages , pool_queued_async_xda_pages , pool_queued_async_temp_data_pages , pool_queued_async_temp_index_pages , pool_queued_async_temp_xda_pages , pool_failed_async_data_reqs , pool_failed_async_index_reqs , pool_failed_async_xda_reqs , pool_failed_async_temp_data_reqs , pool_failed_async_temp_index_reqs , pool_failed_async_temp_xda_reqs , pool_failed_async_other_reqs , total_peds , disabled_peds , post_threshold_peds , total_peas , post_threshold_peas , tq_sort_heap_requests , tq_sort_heap_rejections , prefetch_wait_time , prefetch_waits , pool_data_gbp_indep_pages_found_in_lbp , pool_index_gbp_indep_pages_found_in_lbp , pool_xda_gbp_indep_pages_found_in_lbp , 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 , ida_sends_total , ida_send_volume , ida_recv_wait_time , ida_recvs_total , ida_recv_volume , rows_deleted , rows_inserted , rows_updated , total_hash_joins , total_hash_loops , hash_join_overflows , hash_join_small_overflows , post_shrthreshold_hash_joins , total_olap_funcs , olap_func_overflows , int_rows_deleted , int_rows_inserted , int_rows_updated , comm_exit_wait_time , comm_exit_waits , pool_col_l_reads , pool_temp_col_l_reads , pool_col_p_reads , pool_temp_col_p_reads , pool_col_lbp_pages_found , pool_col_writes , pool_col_gbp_l_reads , pool_col_gbp_p_reads , pool_col_gbp_invalid_pages , pool_col_gbp_indep_pages_found_in_lbp , pool_queued_async_col_reqs , pool_queued_async_temp_col_reqs , pool_queued_async_col_pages , pool_queued_async_temp_col_pages , pool_failed_async_col_reqs , pool_failed_async_temp_col_reqs , total_col_proc_time , total_col_time , total_col_executions , post_threshold_hash_joins , pool_caching_tier_page_read_time , pool_caching_tier_page_write_time , pool_data_caching_tier_l_reads , pool_index_caching_tier_l_reads , pool_xda_caching_tier_l_reads , pool_col_caching_tier_l_reads , pool_data_caching_tier_page_writes , pool_index_caching_tier_page_writes , pool_xda_caching_tier_page_writes , pool_col_caching_tier_page_writes , pool_data_caching_tier_page_updates , pool_index_caching_tier_page_updates , pool_xda_caching_tier_page_updates , pool_col_caching_tier_page_updates , pool_data_caching_tier_pages_found , pool_index_caching_tier_pages_found , pool_xda_caching_tier_pages_found , pool_col_caching_tier_pages_found , pool_data_caching_tier_gbp_invalid_pages , pool_index_caching_tier_gbp_invalid_pages , pool_xda_caching_tier_gbp_invalid_pages , pool_col_caching_tier_gbp_invalid_pages , pool_data_caching_tier_gbp_indep_pages_found , pool_index_caching_tier_gbp_indep_pages_found , pool_xda_caching_tier_gbp_indep_pages_found , pool_col_caching_tier_gbp_indep_pages_found , total_hash_grpbys , hash_grpby_overflows , post_threshold_hash_grpbys , post_threshold_olap_funcs , ANY content ( skip ) {zero or more (*)} )

Attributes:

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

stmt_value_index

The element represents the position of the input parameter marker or host variable used in the SQL statement. See monitor element stmt_value_index - Value index monitor elementfor more details.

Contained by:

Element content:
Type Facet
xs:int  

stmt_value_isnull

The element shows whether a data value associated with the SQL statement is the NULL value. See monitor element stmt_value_isnull - Value has null value monitor elementfor more details.

Contained by:

Attributes:

QName Type Fixed Default Use Annotation
id xs:int required  

stmt_value_isreopt

The element shows whether the variable was used during statement reoptimization. See monitor element stmt_value_isreopt - Variable used for statement reoptimization monitor elementfor more details.

Contained by:

Attributes:

QName Type Fixed Default Use Annotation
id xs:int required  

stmt_value_type

stmt_value_type - Value type monitor element

Contained by:

Element content:
Type Facet
xs:string Max length: 16

stmt_value_data

The element contains a string representation of a data value associated with an SQL statement. See monitor element stmt_value_data - Value data monitor elementfor more details.

Contained by:

Element content:
Type Facet
xs:string Max length: 32768

agent_wait_time

See monitor element agent_wait_time - Agent wait time monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_compilations

See monitor element total_compilations - Total compilations monitor elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_implicit_compilations

See monitor element total_implicit_compilations - Total implicit compilations monitor elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_runstats

See monitor element total_runstats - Total runtime statistics monitor elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_reorgs

See monitor element total_reorgs - Total reorganizations monitor elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_loads

See monitor element total_loads - Total loads monitor elementfor 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 elementfor 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 elementfor 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 elementsfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

int_commits

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

Contained by: system_metrics

Element content:
Type Facet
xs:long  

int_rollbacks

See monitor element int_rollbacks - Internal rollbacks monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementsfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_stats_fabrication_proc_time

See monitor element total_stats_fabrication_proc_time - Total statistics fabrication processing time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_stats_fabrication_time

See monitor element total_stats_fabrication_time - Total statistics fabrication time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_stats_fabrications

See monitor element total_stats_fabrications - Total statistics fabrications monitor elementsfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_sync_runstats_proc_time

See monitor element total_sync_runstats_proc_time - Total synchronous RUNSTATS processing time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_sync_runstats_time

See monitor element total_sync_runstats_time - Total synchronous RUNSTATS time monitor elementsfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_sync_runstats

See monitor element total_sync_runstats - Total synchronous RUNSTATS activities monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

app_act_completed_total

See monitor element app_act_completed_total - Total successful external coordinator activities monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

app_act_aborted_total

See monitor element app_act_aborted_total - Total failed external coordinator activities monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

app_act_rejected_total

See monitor element app_act_rejected_total - Total rejected external coordinator activities monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_connect_request_proc_time

See monitor element total_connect_request_proc_time - Total connection or switch user request processing time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_connect_request_time

See monitor element total_connect_request_time - Total connection or switch user request time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_connect_requests

See monitor element total_connect_requests - Connection or switch user requests monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_connect_authentication_proc_time

See monitor element total_connect_authentication_proc_time - Total connection authentication processing time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_connect_authentication_time

See monitor element total_connect_authentication_time - Total connection or switch user authentication request time monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

total_connect_authentications

See monitor element total_connect_authentications - Connections or switch user authentications performed monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

uow_client_idle_wait_time

See monitor element uow_client_idle_wait_time - Client idle time within a unit of work monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

dynamic_sql_stmts

See monitor element dynamic_sql_stmts - Dynamic SQL Statements Attempted monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

static_sql_stmts

See monitor element static_sql_stmts - Static SQL Statements Attempted monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

failed_sql_stmts

See monitor element failed_sql_stmts - Failed Statement Operations monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

select_sql_stmts

See monitor element select_sql_stmts - Select SQL Statements Executed monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

uid_sql_stmts

See monitor element uid_sql_stmts - Update/Insert/Merge/Delete SQL Statements Executed monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

ddl_sql_stmts

See monitor element ddl_sql_stmts - Data Definition Language (DDL) SQL Statements monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

merge_sql_stmts

See monitor element merge_sql_stmts - Merge SQL statements executed monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

xquery_stmts

See monitor element xquery_stmts - XQuery Statements Attempted monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

implicit_rebinds

See monitor element implicit_rebinds - number of implicit rebinds monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

binds_precompiles

See monitor element binds_precompiles - Binds/Precompiles Attempted monitor elementfor more details.

Contained by: system_metrics

Element content:
Type Facet
xs:long  

call_sql_stmts

See monitor element call_sql_stmts - CALL SQL statements executed monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_waits

See monitor element lock_waits - Lock waits monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_read

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

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_modified

See monitor element rows_modified - Rows modified monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_returned

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

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

deadlocks

See monitor element deadlocks - Deadlocks detected monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

sort_overflows

See monitor element sort_overflows - Sort overflows monitor elementfor 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 elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_sorts

See monitor element total_sorts - Total sorts monitor elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementsfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor 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 elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

thresh_violations

See monitor element thresh_violations - Number of threshold violations monitor elementfor 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 elementfor 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 elementsfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_wait_time_global

See monitor element lock_wait_time_global - Lock wait time global monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_waits_global

See monitor element lock_waits_global - Lock waits global monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

reclaim_wait_time

See monitor element reclaim_wait_time - Reclaim wait time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

spacemappage_reclaim_wait_time

See monitor element spacemappage_reclaim_wait_time - Space map page reclaim wait time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_timeouts_global

See monitor element lock_timeouts_global - Lock timeouts global monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_escals_maxlocks

See monitor element lock_escals_maxlocks - Number of maxlocks lock escalations monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_escals_locklist

See monitor element lock_escals_locklist - Number of locklist lock escalations monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

lock_escals_global

See monitor element lock_escals_global - Number of global lock escalations monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

cf_wait_time

See monitor element cf_wait_time - cluster caching facility wait time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

cf_waits

See monitor element cf_waits - Number of cluster caching facility waits monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_gbp_l_reads

See monitor element pool_data_gbp_l_reads - Group buffer pool data logical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_gbp_p_reads

See monitor element pool_data_gbp_p_reads - Group buffer pool data physical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_lbp_pages_found

See monitor element pool_data_lbp_pages_found - Local buffer pool found data pages monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_gbp_invalid_pages

See monitor element pool_data_gbp_invalid_pages - Group buffer pool invalid data pages monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_gbp_l_reads

See monitor element pool_index_gbp_l_reads - Group buffer pool index logical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_gbp_p_reads

See monitor element pool_index_gbp_p_reads - Group buffer pool index physical reads monitor elementsfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_lbp_pages_found

See monitor element pool_index_lbp_pages_found - Local buffer pool index pages found monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_gbp_invalid_pages

See monitor element pool_index_gbp_invalid_pages - Group buffer pool invalid index pages monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_gbp_l_reads

See monitor element pool_xda_gbp_l_reads - Group buffer pool XDA data logical read requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_gbp_p_reads

See monitor element pool_xda_gbp_p_reads - Group buffer pool XDA data physical read requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_lbp_pages_found

See monitor element pool_xda_lbp_pages_found - Local buffer pool XDA data pages found monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_gbp_invalid_pages

See monitor element pool_xda_gbp_invalid_pages - Group buffer pool invalid XDA data pages monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

evmon_wait_time

See monitor element evmon_wait_time - Event monitor wait time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

evmon_waits_total

See monitor element evmon_waits_total - Event monitor total waits monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_extended_latch_wait_time

See monitor element total_extended_latch_wait_time - Total extended latch wait time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_extended_latch_waits

See monitor element total_extended_latch_waits - Total extended latch waits monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_disp_run_queue_time

See monitor element total_disp_run_queue_time - Total dispatcher run queue time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_data_reqs

See monitor element pool_queued_async_data_reqs - Data prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_index_reqs

See monitor element pool_queued_async_index_reqs - Index prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_xda_reqs

See monitor element pool_queued_async_xda_reqs - XDA prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_data_reqs

See monitor element pool_queued_async_temp_data_reqs - Data prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_index_reqs

See monitor element pool_queued_async_temp_index_reqs - Index prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_xda_reqs

See monitor element pool_queued_async_temp_xda_reqs - XDA data prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_other_reqs

See monitor element pool_queued_async_other_reqs - Other requests handled by prefetchers monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_data_pages

See monitor element pool_queued_async_data_pages - Data pages prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_index_pages

See monitor element pool_queued_async_index_pages - Index pages prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_xda_pages

See monitor element pool_queued_async_xda_pages - XDA pages prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_data_pages

See monitor element pool_queued_async_temp_data_pages - Data pages prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_index_pages

See monitor element pool_queued_async_temp_index_pages - Index pages prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_xda_pages

See monitor element pool_queued_async_temp_xda_pages - XDA data pages prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_data_reqs

See monitor element pool_failed_async_data_reqs - Failed data prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_index_reqs

See monitor element pool_failed_async_index_reqs - Failed index prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_xda_reqs

See monitor element pool_failed_async_xda_reqs - Failed XDA prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_temp_data_reqs

See monitor element pool_failed_async_temp_data_reqs - Failed data prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_temp_index_reqs

See monitor element pool_failed_async_temp_index_reqs - Failed index prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_temp_xda_reqs

See monitor element pool_failed_async_temp_xda_reqs - Failed XDA prefetch requests for temporary table spaces monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_other_reqs

See monitor element pool_failed_async_other_reqs - Failed non-prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_peds

See monitor element total_peds - Total partial early distincts monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

disabled_peds

See monitor element disabled_peds - Disabled partial early distincts monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_threshold_peds

See monitor element post_threshold_peds - Partial early distincts threshold monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_peas

See monitor element total_peas - Total partial early aggregations monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_threshold_peas

See monitor element post_threshold_peas - Partial early aggregation threshold monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

tq_sort_heap_requests

See monitor element tq_sort_heap_requests - Table queue sort heap requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

tq_sort_heap_rejections

See monitor element tq_sort_heap_rejections - Table queue sort heap rejections monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

prefetch_wait_time

See monitor element prefetch_wait_time - Time waited for prefetch monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

prefetch_waits

See monitor element prefetch_waits - Prefetcher wait count monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_gbp_indep_pages_found_in_lbp

See monitor element pool_data_gbp_indep_pages_found_in_lbp - Group buffer pool independent data pages found in local buffer pool monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_gbp_indep_pages_found_in_lbp

See monitor element pool_index_gbp_indep_pages_found_in_lbp - Group buffer pool independent index pages found in local buffer pool monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_gbp_indep_pages_found_in_lbp

See monitor element pool_xda_gbp_indep_pages_found_in_lbp - Group buffer pool XDA independent pages found in local buffer pool monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_recv_waits_total

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_recv_waits_total

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_tq_send_waits_total

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_message_send_waits_total

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_send_waits_total

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

fcm_recv_waits_total

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

ida_send_wait_time

See monitor element ida_send_wait_time - Time spent waiting to send data monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

ida_sends_total

See monitor element ida_sends_total - Number of times data sent monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

ida_send_volume

See monitor element ida_send_volume - Total data volume sent monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

ida_recv_wait_time

See monitor element ida_recv_wait_time - Time spent waiting to receive data monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

ida_recvs_total

See monitor element ida_recvs_total - Number of times data received monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

ida_recv_volume

See monitor element ida_recv_volume - Total data volume received monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_deleted

See monitor element rows_deleted - Rows deleted monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_inserted

See monitor element rows_inserted - Rows inserted monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

rows_updated

See monitor element rows_updated - Rows updated monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_hash_joins

See monitor element total_hash_joins - Total Hash Joins monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_hash_loops

See monitor element total_hash_loops - Total Hash Loops monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

hash_join_overflows

See monitor element hash_join_overflows - Hash Join Overflows monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

hash_join_small_overflows

See monitor element hash_join_small_overflows - Hash Join Small Overflows monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_shrthreshold_hash_joins

See monitor element post_shrthreshold_hash_joins - Post threshold hash joins monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_olap_funcs

See monitor element total_olap_funcs - Total OLAP Functions monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

olap_func_overflows

See monitor element olap_func_overflows - OLAP Function Overflows monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

int_rows_deleted

See monitor element int_rows_deleted - Internal Rows Deleted monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

int_rows_inserted

See monitor element int_rows_inserted - Internal Rows Inserted monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

int_rows_updated

See monitor element int_rows_updated - Internal Rows Updated monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

comm_exit_wait_time

See monitor element comm_exit_wait_time - Communication exit wait time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

comm_exit_waits

See monitor element comm_exit_waits - Communication exit number of waits monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_l_reads

See monitor element pool_col_l_reads - Buffer pool column-organized logical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_col_l_reads

See monitor element pool_temp_col_l_reads - Buffer pool column-organized temporary logical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_p_reads

See monitor element pool_col_p_reads - Buffer pool column-organized physical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_temp_col_p_reads

See monitor element pool_temp_col_p_reads - Buffer pool column-organized temporary physical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_lbp_pages_found

See monitor element pool_col_lbp_pages_found - Buffer pool column-organized LBP pages found monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_writes

See monitor element pool_col_writes - Buffer pool column-organized writes monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_gbp_l_reads

See monitor element pool_col_gbp_l_reads - Buffer pool column-organized GBP logical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_gbp_p_reads

See monitor element pool_col_gbp_p_reads - Buffer pool column-organized GBP physical reads monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_gbp_invalid_pages

See monitor element pool_col_gbp_invalid_pages - Buffer pool column-organized GBP invalid data pages monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_gbp_indep_pages_found_in_lbp

See monitor element pool_col_gbp_indep_pages_found_in_lbp - Buffer pool column-organized GBP independent pages found in local buffer pool monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_col_reqs

See monitor element pool_queued_async_col_reqs - Column-organized prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_col_reqs

See monitor element pool_queued_async_temp_col_reqs - Column-organized temporary prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_col_pages

See monitor element pool_queued_async_col_pages - Column-organized page prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_queued_async_temp_col_pages

See monitor element pool_queued_async_temp_col_pages - Column-organized page temporary prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_col_reqs

See monitor element pool_failed_async_col_reqs - Failed column-organized prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_failed_async_temp_col_reqs

See monitor element pool_failed_async_temp_col_reqs - Failed column-organized temporary prefetch requests monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_col_proc_time

See monitor element total_col_proc_time - Total column-organized processing time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_col_time

See monitor element total_col_time - Total column-organized time monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_col_executions

See monitor element total_col_executions - Total column-organized executions monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_threshold_hash_joins

See monitor element post_threshold_hash_joins - Hash Join Threshold monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_caching_tier_page_read_time

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_caching_tier_page_write_time

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_caching_tier_l_reads

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_caching_tier_l_reads

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_caching_tier_l_reads

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_caching_tier_l_reads

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_caching_tier_page_writes

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_caching_tier_page_writes

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_caching_tier_page_writes

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_caching_tier_page_writes

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_caching_tier_page_updates

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_caching_tier_page_updates

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_caching_tier_page_updates

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_caching_tier_page_updates

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_caching_tier_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_caching_tier_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_caching_tier_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_caching_tier_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_caching_tier_gbp_invalid_pages

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_caching_tier_gbp_invalid_pages

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_caching_tier_gbp_invalid_pages

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_caching_tier_gbp_invalid_pages

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_data_caching_tier_gbp_indep_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_index_caching_tier_gbp_indep_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_xda_caching_tier_gbp_indep_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

pool_col_caching_tier_gbp_indep_pages_found

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

total_hash_grpbys

See monitor element total_hash_grpbys - Total hash GROUP BY operations monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

hash_grpby_overflows

See monitor element hash_grpby_overflows - Hash GROUP BY overflows monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_threshold_hash_grpbys

See monitor element post_threshold_hash_grpbys - Hash GROUP BY threshold monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long  

post_threshold_olap_funcs

See monitor element post_threshold_olap_funcs - OLAP Function Threshold monitor elementfor more details.

Contained by: system_metrics activity_metrics

Element content:
Type Facet
xs:long