Top Consumers - Activities

Purpose

This view shows the user which activities consume the most resources. Activities are generally queries, but long running DDL and LOAD activities are also included here.

Summaries and Histograms (Gauges)

Metrics Shown

There is a grid with a row for each resource that is tracked. Each row names the resource and shows

Item no, so the grid can be restored to its canonical order if the user sorts on a different column
Server resource (CPU, Rows Read, etc.)
The application handle for the activity that has consumed the most of that resource
What percentage of that resource this particular activity has consumed, relative to consumption by other current activities
How many rows read, CPU seconds used, etc.
The name of the application that started this activity
Activity type (READ_DML, LOAD, etc)
Statement text (for SQL, null for LOAD activities)

The percentage shown in “Resource Usage” is found by adding up that resource across all current activities and dividing the value for the top consuming activity into it.

If a resource is 0 for all activities, then there is no top consumer and we show null (dash in the grid) for all the columns except Item No and Server Resource.

0 CPU Time

Source: mon_get_activity.total_cpu_time

1 Elapsed time

Source: mon_get_activity.local_start_time

Show the different between local_start_time and current timestamp.

2 Statement Exec Time

Source: mon_get_activity.stmt_exec_time

3 Num Agents

Source: mon_get_activity.num_agents

4 Rows Read

Source: mon_get_activity.rows_read

5 Rows Returned