Notice: will be retired soon. Please visit our new site at
Spotlight on Oracle
Visit to buy this product online.
Buy Online »
Case Study
See how Spotlight on Oracle helped Vodafone resolve its database performance problems 70 percent faster and provided a 500 percent ROI for Ireland’s leading mobile phone operator.
Read now »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
Tech Brief
Learn how to collect and analyze performance metrics to predict the future behavior of your Oracle databases in this tech brief about predictive diagnostics.
Read now »

Spotlight on Oracle

The Fastest Way to Find and Fix Performance Bottlenecks

Spotlight® on Oracle provides visual, real-time diagnostics, so you can quickly eliminate bottlenecks in Oracle and Oracle RAC environments. And because Spotlight helps you save time finding and fixing performance issues, you can reduce downtime and IT costs. Show your boss the improvements you can make and the corresponding ROI you can achieve with Spotlight on Oracle.

With Spotlight, you can:

  • Pinpoint and resolve bottlenecks quickly
  • Prevent or minimize unplanned downtime
  • Improve service levels for users and stakeholders
  • Increase knowledge of Oracle performance
  • Gain visibility into database processes — including RAC (node, cluster, interconnect)

We also offer a Spotlight® on Oracle Exadata component as part of the Toad® DBA Suite for Oracle - Exadata Edition. Learn more and download a trial.


  • Real-Time Diagnostics — See graphical flows that illustrate the rate at which data moves between components. Get audio or visual alerts of potential bottlenecks if any component begins to exceed performance thresholds. Extend the ability to play back past instances.
  • Enhanced Top SQL Drilldown — Get a consolidated view of SQL statements to identify those consuming the most resources.
  • Analyze Trace Files — Gain a graphical view of the contents of Oracle trace files to see how Oracle is processing SQL statements and how resources are being used to execute those statements.
  • Troubleshooting Instance — Leverage a baseline for normal activity from a built-in calibration process. Set up thresholds and get warnings of impending problems from visual or audible alerts.
  • Alert Log Reader — Read a chronological list of messages and errors that have occurred in the Oracle database, offering quick identification of areas to fix.
  • Diagnostics for Unix, Linux and Windows OS — See real-time graphic displays of the flow of data in your Unix, Linux, and Windows operating systems to get diagnostics on the server OS.
  • Predictive Diagnostics — Predict future performance of individual SQL statements. These include increases in contention that might result in database performance degradation if current trends continue and prediction of optimum system resource requirements via performance modeling.
  • Diagnostics for RAC Infrastructure — View an aggregate of performance data across all instances of the cluster. See a consolidated view of cluster-level alarms.
  • Dataguard Diagnostics — Monitor and measure performance of Dataguard, including data latency and all data flows and processes.

Sys Reqs

Before installing Spotlight on Oracle, ensure your system meets the following minimum hardware and software requirements:

Client requirements


1.2 GHz


512 MB  

Hard disk space

1 GB

Operating system

Microsoft® Windows® Server 2003 (32-Bit and 64-Bit), 2008 (64-Bit), and 2012 (64-Bit), Microsoft® Windows® 7 and 8 (32-Bit and 64-Bit)
Microsoft® Windows® Vista® Business (32-Bit and 64-Bit) Service Pack 1 or later
Microsoft® Windows® XP® Professional (32-Bit and 64-Bit) Service Pack 1 or later

Microsoft® .NET® 3.5 Service Pack 1
Oracle® SQL*Net® 2.3.4 or later
Oracle® full or instant client 9.2, 10g, 11g, 12c

Monitored database servers

Oracle, 10g, 11g, 12c  

Oracle® RAC®

16 instances in a cluster

Oracle® Exadata® Storage Servers (cells)

Linux® Kernel® 2.6

Cloud Database Services

Oracle databases running on Amazon® EC2®


5.0.3 and later

Virtualization support



Citrix® on Windows Server 2003 Enterprise Server (Service Pack 2) using the Citrix® MetaFrame® Presentation Server 5.0 and Citrix® Presentation Server Clients 10.2.


VMware® workstations


VMware® ESX® servers
Oracle® Virtualization (OVM)

Note: May work in additional virtualization environments.

Download free trial to see the full list of system requirements.