Database Reference
In-Depth Information
load map shows information similar to the one displayed by the top consumer table, but
uses a treemap instead of a table. For example, Figure 4-8 shows the data for the same period
as for Figure 4-7 . Also, for the load map, you can hover over one of the rectangles to get
detailed information about it.
A
Figure 4-8. Load map showing the top 5 SQL statement for the time period selected in Figure 4-5
Event though the activity chart and the load map are used to display data, in ASH Analytics, they play another
important role. With them you can in fact restrict the analyzed data by selecting one or several top consumers. In
other words, with them you can define filters that apply to the charts. You can, for example, do the following:
Display the top SQL statements and select the most time-consuming (c13sma6rkr27c)
Display the top wait classes and select the most time-consuming (User I/O)
db file sequential read )
Display the top wait events and select the most time-consuming (
Display the top modules
The result of these operations is shown in Figure 4-9 . Notice the filters defined through the load map at the top.
Based on that chart, you can infer that the whole load for this particular selection is produced by a single
module (New Order).
 
Search WWH ::




Custom Search