Spotlight on Oracle graphically displays, in real time, the actual server processes and flow of data in your Oracle database so you can quickly identify congested areas and take appropriate corrective action.
Shows a visual representation of process flows within an Oracle instance, allowing you to observe actual database activity in real time
Identifies bottlenecks using flows, graphs and visual icons
Displays the details of problem areas, including Most Active Sessions, Inefficient SQL, Locks/Latches/Wait Events, and Disk I/O, helping you resolve performance problems quickly
Alerts you with an audio or visual alarm if any Oracle component is forming a bottleneck
Snaps into Quest Software¡¯s I/Watch for 24x7 unattended monitoring of systems and databases
Simultaneously diagnoses multiple database instances
As a DBA, you can't keep your Oracle database running optimally if you can't see and respond quickly to database performance problems. Spotlight on Oracle, the revolutionary performance diagnostic and resolution tool for Oracle databases, helps you correct problems before they worsen. No other tool graphically displays, in real time, the actual sever processes and flow of data in your Oracle database. From Spotlight on Oracle's intuitive user interface, you can quickly identify congested areas in your database and take appropriate corrective action.

From an overview screen, you can view the most active user sessions and SQL statements, locks & latches, wait events and disk I/O to pinpoint and alleviate problem areas as they occur. And when you need more detailed information, you can drill down from any of these views to receive in-depth charts of underlying statistics.

Because the run-time nature of each database is unique, Spotlight on Oracle offers a learning facility that automatically sets a baseline of normal activity for each instance. This allows Spotlight on Oracle to automatically set thresholds and display alerts when it detects performance bottlenecks. Diagnosing and resolving performance problems has never been easier.

Spotlight is just one component of Quest Software's integrated Production Support solutions, which include: real-time diagnostic and resolutions, unattended enterprise monitoring, SQL statement tuning, space reorganization, and capacity planning.