The Fastest Way to Find and Fix Performance Bottlenecks in the Oracle Database

Key Benefits

• Discover hard-to-ind bottlenecks
• Eliminate guesswork in identifying problems in the Oracle database 
• View an intuitive GUI, providing instant visual comprehension of performance bottlenecks for quick time to resolution 
• Prevent or minimize unplanned database downtime

There is an explosion of data today leading to database performance bottlenecks that can cripple your
organization. You must ind these bottlenecks before applications are afected, but it!ˉs nearly impossible
to do so without a clear view of I/O and user activity. And relying on manual methods to diagnose and
resolve every issue is time-consuming and ineicient, especially when you consider that the Oracle
environment is getting more and more complex. You need automated solutions to quickly identify,
diagnose and/or resolve performance problems.

Spotlight on Oracle allows you to rapidly discover performance bottlenecks in your Oracle database. It
shows you the performance status!aand diagnoses the health!aof your environment, both in real tim
and historically using a granular record-and-playback function. Additionally, Spotlight automatically sets a
baseline of normal activity for each instance, and then establishes thresholds. Based on these thresholds,
Spotlight delivers alerts as it detects performance bottlenecks of any kind. Spotlight provides real-time
diagnostics, granting you the fastest way to ind and ix performance bottlenecks.

Spotlight on Oracle provides an intuitive interface displaying the architecture of your Oracle environment for immediate diagnosis of performance bottlenecks

See which edition of Spotlight on Oracle is right for you:

Spotlight on Oracle Standard Edition(part of Toad DBA Suite)
Identify and diagnose thousands of performance issues!awhether they!ˉre related to a specific user
resource-intensive SQL transaction, I/O bottleneck, lock wait or other exact source. Automatically set
baselines and thresholds, and display alerts.

Spotlight on Oracle Professional Edition
Get all of the Standard Edition!ˉs capabilities plus OS diagnostics to quickly correct performance
problems in Linux, Unix and Windows. In addition, a new capability called !°predictive diagnostics!
goes beyond detecting and diagnosing immediate performance problems!aanticipating future
performance issues before they impact the database.

Spotlight on Oracle Expert Edition

Get all of the capabilities from the Standard and Professional Editions, plus automated SQL tuning
to maximize SQL performance, and diagnostics for Oracle RAC (Real Application Clusters) to detect
performance bottlenecks from the node to the cluster and the interconnect.

Comparison Chart of Spotlight on Oracle Editions:

About Quest Sofeware，inc.

Now more than ever, organizations need to work smart and improve eiciency. Quest Software creates and
supports smart systems management products!ahelping our customers solve everyday IT challenges faster and
easier. Visit  for more information.