Database Reference
In-Depth Information
The Load Map
The load map, shown in Figure
9-32
, is the second choice for viewing data from ASH Analytics. The Activity graph is
the view most administrators are familiar with from years of Enterprise Manager experience. The load map is a new
way to display all data found in ASH Analytics, but often more clear for nonadministrator groups.
Figure 9-32.
An ASH Analytics advanced load map displaying wait class and SQL ID
Ti
■
the load map view is often lost on the administrator, who is familiar with and has training to understand data
displayed from top activity. the load map displays performance data in a way that has more visual impact.
The load map in Figure
9-32
shows SQL ID
csu5p1yyp1p40
as almost 50 percent of the resource usage in the
environment. For a nonadministrator, this representation provides a clearer picture of the SQL affecting performance
than a graph display of the same data, which might very well be misleading.
The same load map can then be changed to display the SQL IDs, but this time sorted by user session. Figure
9-33
shows the same load as in Figure
9-32
, but the percentages are broken out by user session first, and then by SQL ID
within each session.
Figure 9-33.
An ASH Analytics advanced load map, displayed by user session and SQL ID
