The Console
The Performance Analysis window features four modes:
Home Mode—Offers at-a-glance monitoring of primary system health measurements, and provides the starting point for drilldown analysis in one easy-to-understand digital dashboard. This view offers user-configurable, alarm-enabled, normative baseline, advisory and applied knowledgebase toolsets to optimize user monitoring and tuning efforts; Performance Analysis's Home mode intuitively focuses users' attention on those instance and system aspects most in need of attention. The Home view is divided into four distinct tabs:
Overview tab: Displays overall instance and system activity in a set of intuitive gauges; the top set delineates instance activity for baseline analysis, and displays individual resource performance as compared to established thresholds, while the bottom set depicts both instance-level resource breakdowns compared to established thresholds, and system component performance indicators.
Performance Advisories tab: Identifies and describes significant performance issues that affect instance and/or database operation. One click accesses both Quest's context-sensitive knowledgebase and suggests intelligent solutions to the problem(s).
Best Practices tab: Analyzes and identifies database configuration and operating conditions that are non-optimal or that violate industry "best practices" for specific Oracle versions.
E-Business tab: Provides analytical reports on key Oracle E-Business operational areas, including application performance and security characteristics.
Real-Time Mode— Offer both real-time and recent (up to the last 60 minutes) monitoring of both instance and session level activity. Current activity can be tracked down to the statement currently executing by double-clicking any active session displayed in the Current Sessions node.
History Mode— Facilitates problem detection, diagnosis, and resolution by means of baseline and dimensional analysis. Historical performance data can be analyzed down to increasingly refined levels through the iInstance overview, and users can create and maintain custom shortcuts (cube views) and user defined collections.
Reports Mode—Assists the DBA/Manager in automating key tasks and in understanding system behavior with a variety of reports. Reports can be created to span all dimensions and filters in a variety of output formats for further inquiry and analysis.
A second row of icons, consists of two sets:
individual icons for:
Agent Refresh
,
Client Configuration
agent configuration
Help
; context-sensitive toolbar icons for the various modes:
