Throughput - Skew Monitor

This view presents data useful in assessing skew in access patterns.  When a query accesses more data on some members than on others, the more heavily loaded members become bottlenecks, making the whole query take longer.

(none)

Member

Source: mon_get_service_subclass.member

CPU Time

Source: mon_get_service_subclass.total_cpu_time

Logical Reads/s

Logical reads is a better measure of access patterns than rows read because it includes index accesses.

Source: mon_get_service_subclass

pool_data_l_reads + pool_index_l_reads + pool_xda_l_reads + pool_col_l_reads +

pool_temp_data_l_reads + pool_temp_index_l_reads + pool_temp_xda_l_reads + pool_temp_col_l_reads

Logical Temp Reads/s

Source: mon_get_service_subclass

pool_temp_data_l_reads + pool_temp_index_l_reads + pool_temp_xda_l_reads + pool_temp_col_l_reads

Rows Read/s

Source: mon_get_service_subclass.rows_read

Rows Modified/s

Source: mon_get_service_subclass.rows_modified

TQ Recvs/s

Source: mon_get_service_subclass.fcm_tq_recvs_total

TQ Sends/s

Source: mon_get_service_subclass.fcm_tq_sends_total

TQ Spills/s

Source: mon_get_service_subclass.tq_tot_send_spills

Overflows/s

Source: mon_get_service_subclass

sort_overflows + hash_join_overflows + olap_func_overflows + hash_grpby_overflows

FCM Volume (KB/s)

Source: mon_get_service_subclass

(fcm_recv_volume + fcm_send_volume) / 1024.0

FCM Buffers Sent/s

Source: mon_get_service_subclass.fcm_sends_total

FCM Buffers Recvd/s

Source: mon_get_service_subclass.fcm_recvs_total

Activities Completed/s

Source: mon_get_service_subclass.act_completed_total

Requests/s

Source: mon_get_service_subclass.rqsts_completed_total

In-flight Activities

Source:

select count(*) from table(wlm_get_workload_occurrence_activities(null,member))

Member, ascending

Keyboard navigation: VtJ

Dedicated shortcut key: alt-J