Database Reference
In-Depth Information
Dimensions for the same load map can be adjusted, and sample size can be changed (see Figure
9-34
).
Figure 9-34.
An ASH Analytics load map with diminished dimensions and sample size
The example in Figure
9-34
displays only the user session information. If you use an advanced load map setting
and limiting the samples to three, you can display even smaller subsets of sample information.
By then increasing to three dimensions, building each of these dimensions by wait class, SQL ID, and client,
you can create a load map that shows the SQL ID as the header in each section, along with client information and
then the wait class indicator (see Figure
9-35
).
Figure 9-35.
ASH Analytics, displaying an advanced, three-dimension load map
ASH Analytics is the future of Top Activity. With the advancements in ASH expected in future releases of Oracle,
ASH Analytics will continue to provide more-enhanced performance data for the Oracle database environment.
SQL Monitoring
SQL Monitor, introduced in Oracle 11g, has been hailed as one of the best new features. The graphical display of SQL
Monitor within Enterprise Manager offers a secondary view to session data in the database (see Figure
9-36
).
