Spotlight on Oracle

Shop our wide range of secure and reliable desktops for your business. Plus, enjoy free delivery on select PCs. Go to Offers

Diagnose performance problems to quickly fix bottlenecks.

visualize and diagnose performance problems within your Oracle and Oracle RAC environments in real time to quickly eliminate bottlenecks.

Software Spotlight on Oracle


Benefit from these key features with Spotlight on Oracle:

Real-time diagnostics
Graphical flows show you the rate that data moves between components. If any component begins to exceed performance thresholds, you get audio or visual alerts of potential bottlenecks.

Enhanced top SQL drilldown
Gain a comprehensive view of SQL statements, so you can identify where your resources are being consumed most heavily.

Analyze trace files
Get a graphical view of Oracle trace files’ contents to see how and where processing SQL statements consume resources.

Troubleshooting instance
Use the built-in calibration to leverage a baseline for normal activity. Your pre-set data thresholds automatically trigger warnings of impending problems via visual or audible alerts.

Alert log reader
Quickly identify areas you need to fix by reading a chronological list of messages and errors that have occurred in your Oracle database.

Diagnostics for Linux, Unix and Windows OS
Get diagnostics on your server OS by viewing real-time graphic displays of the data flow in your Linux, Unix, or Windows operating systems.

Predictive diagnostics
Predict individual SQL statement’s future performance, including increases in contention that can degrade database performance if trends continue, as well as predicting optimum system resource needs through performance modeling.

Diagnostics for RAC infrastructure
View consolidated performance data across all instances of the cluster, as well as gain a comprehensive picture of cluster-level alarms.

Dataguard diagnostics
Measure the performance of Dataguard, including all data processes and flows, as well as data latency.
With Spotlight™ on Oracle, you can visualize and diagnose performance problems within your Oracle and Oracle RAC environments in real time to quickly eliminate bottlenecks. Spotlight enables you to minimize unplanned downtime, improve service to stakeholders and users, improve your knowledge of Oracle performance, and gain visibility into database processes, including RAC (interconnect, node, cluster). This Oracle diagnostics tool increases your database uptime and reduces IT costs, resulting in fast return on your investment.

You can also get a Spotlight on Oracle Exadata component as part of the Toad™ DBA Suite for Oracle - Exadata Edition. Get more information and download a trial.
  • Client requirements

    1.2 GHz


    512 MB

    Hard disk space
    1 GB

    Operating system
    Microsoft® Windows Server® 2003 (32-Bit and 64-Bit)
    Microsoft Windows Server 2008 (64-Bit)
    Microsoft Windows Server 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 .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®
    MySQL® - 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.
Documents Documents
Download printable materials to gain insight on how this product can help you simplify IT challenges.
Events Events
Peruse webcasts and in-person activities near you to explore the technology behind this product.
Community Community
Get the most from this product as you join your peers and Dell experts to access tools and learn best practices.
Dell KACE K1000 GO App - CRN - 2014 Enterprise App Award

Dell KACE K1000 GO

Winner: CRN 2014 Enterprise App Award

Learn More
Dell KACE K1000 GO App - CRN - 30 Coolest Android and iOS Apps of 2014

Dell KACE K1000 GO

One of CRN's "30 Coolest Android and iOS Apps of 2014"

Learn More
Chat online

Chat online. Ask us anything.

You've got questions, we've got experts who can help.

Chat Online
Dell Software | Contact Us

Contact a Dell Expert

Get help with all your business needs.

Learn More
Dell Software | Support

Software Product Support

Single location for all your product needs.

Learn More
 You can only compare up to 7 products. To compare this item, deselect one of the other 7 products.