Quest Central® for Oracle

Performance Diagnostics with Spotlight®

Quest Central Performance Diagnostics with Spotlight® allows you to quickly discover any performance bottleneck—in real-time or historically—using the granular record and playback function. Spotlight identifies and diagnoses thousands of performance issues, whether it’s a specific user, resource-intensive SQL transaction, I/O bottleneck, lock wait or other exact source. Spotlight on Oracle automatically sets a baseline of normal activity for each instance, and can automatically set thresholds and display alerts when it detects performance bottlenecks of any kind.

**Spotlight on Oracle can now be purchased as a stand-alone product.

Key Benefits

• Identifies thousands of performance problems, both historically or in real time, and provides expert advice to resolve of any type of issue
• Eliminates guesswork in problem identification and resolution
• Extends diagnostic capability to RAC environments

Key Features

• New automation and memory management capability for Oracle9i facilitating the use of the advisories now built into the database
• Discovers hard-to-find bottlenecks that comprise up to 80 percent of performance issues, such as wait events, buffer busy and lock switch
• Displays process flows within an Oracle instance
• Displays comprehensive detail for previously recorded activity
• Provides a comprehensive, context-sensitive help text covering thousands of topics by integrating with Knowledge Xpert for Oracle Administration
• Enables you to set baselines for each individual instance
• Displays the details of problem areas, including Top Sessions, Inefficient SQL, Locks, Latches, Wait Events , and Disk I/O , helping you identify performance problems quickly
• Provides specific tuning advice for tuning latches
• Provides detailed performance information and alarming for RAC
• Integrates tightly with KnowledgeXpert for context-sensitive advice

Quest Central for Oracle integrates Quest Software's industry-leading Oracle tools that have been successfully used for years. Check out the other components: Database Administration, Database Analysis, 24x7 Monitoring, SQL Tuning and Performance Analysis and Live Space Management.

Quest Central database solutions are also available for SQL Server and Sybase.