QCO Spotlight Diagnostics
(module of Quest Central for Oracle Suite)

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.

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.