Welcome to Spotlight® on Oracle

Welcome to Spotlight^® on Oracle

Spotlight^® on Oracle is a powerful diagnostic and resolution tool for Oracle databases. Its unique user interface provides you with an intuitive, visual representation of the activity on your database. Graphical flows illustrate the rate at which data is moving between database components. Observe actual database activity in real time.

The power of Spotlight on Oracle lies in its ability to provide visual and audible warnings if the performance metrics exceed acceptable thresholds. The components and data flows change color to show you the source of the problem. Spotlight on Oracle provides detailed information about a specific component allowing you to pinpoint the source of problems.

Spotlight on Oracle incorporates:

• Predictive Diagnostics
• Spotlight on Oracle Data Guard
• Spotlight on UNIX
• Spotlight on Windows

Notes:

• Spotlight on Oracle RAC requires additional licensing. It enables the diagnosis of Oracle databases on multiple host machines under the Real Application Clusters (RAC) architecture and additionally may include monitoring of Exadata systems depending on the license purchased.
• When delivered as part of the Toad^® DBA Suite for Oracle, Spotlight incorporates SQL Optimizer for Oracle. SQL Optimizer offers a fully automated approach to maximizing SQL performance. It eliminates the manual, time-intensive process of ensuring that SQL code is performing as fast as possible.