Spotlight® on Oracle
Spotlight® on Oracle 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 for 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 be purchased as a stand-alone product or as part of the Quest Central for Oracle suite.
Also, Quest offers Spotlight on RAC, which provides a full diagnostic capability for an Oracle RAC (Real Application Cluster) environment.
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
- Spotlight Data Export Wizard to export descriptive performance information about your database to an XML file which assist hardware vendords in making hardware recommendations
- Integrates tightly with KnowledgeXpert for context-sensitive advice
|