History Mode

Performance Analysis for Oracle

History Mode

The Historical Activity window is the Performance Analysis historical diagnostic activity component.

Performance Analysis introduces OLAP concepts for application performance analysis. The tool facilitates an iteration of detect, diagnose and resolve through examination of the activity dimension of interest.

The data that is displayed reflects the collection settings you specified at installation. The opening displayed History View (and the default view for most view drill downs) is as follows:

  • The left-pane dimension navigation tree. The drilldown feature provides access to any of the key dimensions associated with Oracle databases activity, the tree node dimension display determines what subset of activity is displayed.

  • The upper portion graphically displays the Oracle database wait state instance resource usage in either a baseline normative view or a dynamic activity timeline layered representation. Use the sliding magnification scale: ——O—— to magnify the metric scale range. The period activity is summarized in a Resource Breakdown pie chart. Configurable by Resource and Time parameters, these graphical representations provide you with an intuitive introductory picture and overview tool to the system Oracle activity at a glance.

  • The lower Overview, = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A2>Time Breakdown, Change Tracking and Datafile I/O tabs display explanatory parameters of the system Oracle activity for purposes of greater understanding of the behavior of interest. The display includes a list pane of Oracle and system statistics whose activity you can individually time-line display and focus on through the assorted tab modalities.

Historical data exists from the most recent minute. A wide variety of means exist to view and navigate through the collected historical data, using dimension drill downs, filters, wait state selections, period analyses, and change occurrences.

 

Related Topics