Home Page Intro

Performance Analysis for Oracle

Home Page

The Performance Analysis Home Page offers at-a-glance monitoring of primary system health measurement measurements, and provides the starting point for drilldown analysis in one easy to understand digital dashboard.  This view offers both user-configurable, alarm-enabled normative baseline database advisory and applied knowledgebase toolsets to facilitate optimal user monitoring and tuning efforts;  Users' attentions are intuitively focused on those instance and system aspects most in need of attention.

The Home page is divided into four distinct areas:

  • The upper pane's two components display overall activity:

  • The Workload bar graph displays the total current instance activity relative to a peak periods and is t a measure of instance resource capacity. Use this bar graph to assess overall database health from the relative value within the baseline range, relative to the total workload experienced, and by analyzing any observed performance anomalies.

  • The Instance Workload timeline representation (in either the Baseline or Workload views) displays instance activity over the most recent time period. Use this timeline to identify the specific period of time when notable behavior occurred, either through the occurrence of specific wait events or by reviewing instance activity relative to the baseline.

  • The lower pane's two components display individual dimension period bar graph measurements:

  • The Oracle Resource Breakdown  wait event consumption display helps users understand recent workload activity and whether any specific resource's consumption rate is problematic based on baseline, advisory and anomaly readings.

  • The System Utilization CPU, Memory and Disk capacity usage indicators. Use this display of actual resource utilization to understand your system's throughput as a percentage of the actual total available (capacity) through absolute, baseline and anomaly readings.

Detect, diagnose, and resolve issues with one click. Performance Advisories identify and explain significant performance issues affecting database operation.

One click accesses both Quest's context-sensitive knowledgebase expertise and intelligently suggested solutions. Non-optimal or non-industry "best practices" database configuration and operational conditions are identified at the touch of a button, specific to the Oracle version being monitored.

Key Oracle E-Business operational areas, including application performance and security characteristics, can be analyzed through a one-click application or health review.