Database Reference
In-Depth Information
The main ASH Analytics screen shows data displayed by Average Active Sessions (AAS), viewed by graph or
load map. Numerous drill-down opportunities exist in the main performance view, allowing for distinct research
areas to be investigated.
The upper display of the ASH Analytics main page, shown in Figure
9-27
, can be changed to display data by hour,
day, week, or month. Alternatively, you can customize the display to show more-pertinent data to the monitoring task.
Figure 9-27.
ASH Analytics main performance graph
■
if choosing the max display type for ash analytics, the data will be displayed differently than how other wait
event types commonly would be displayed. ensure that you understand how choosing max will impact the data
dispersion in the graph and load map so that an inaccurate diagnosis does not occur.
Note
Being able to save ASH Analytics data locally to a file or to e-mail an HTML report are valuable options if you
need to retain the data or provide information to key members of the team. From the main view, you can also expand
the window to full screen and change the refresh interval. Arrows at the left and right of the timeline enable you to
easily maneuver to earlier timelines or future ones if refreshes have been stopped.
The gray highlighted section in the window, as shown in Figure
9-27
, quickly draws the administrator's eye down,
further detailing a 5-minute sample of ASH data to the graph, including wait events and defaulting with Wait Class events.
The lower Activity pane of the ASH Analytics page, shown in Figure
9-28
, displays data in a format similar to Top
Activity, but the data is based on the
V$ACTIVE_SESSION_HISTORY
view and has more performance data available for
access from the links shown.
Figure 9-28.
The Activity pane for ASH Analytics
The SQL ID section at the lower left links to the SQL Details page. The User Session section on the right links to
the Session Details page. The drop-down Wait Class options are extensive, as seen in Figure
9-29
.
