The FASTEST way to find and fix Oracle performance bottlenecksSpotlight® on OracleThere is an explosion of data today, and performance bottlenecks impact your organization. You need a solution to identify and diagnose performance problems quickly. Spotlight on Oracle enables real-time diagnostics, providing the fastest way to find and fix performance bottlenecks in your Oracle and Oracle RAC database environments. Key Benefits - Eliminate guesswork in identifying and fixing issues in the Oracle database
- Instant visual comprehension, via an intuitive GUI, of performance bottlenecks for quick time to resolution
- Prevent or minimize unplanned downtime of the database
- Full diagnostic capabilities whether at the node, cluster or interconnect level for Oracle Real Application Cluster (RAC) environments
 Spotlight on Oracle includes a comprehensive home page which displays all critical database components at a glance for easy detection of bottlenecks and quick diagnosis. |  Spotlight on Oracle with RAC Diagnostics graphically represents your RAC cluster displaying the essential components including: individual nodes, the interconnect, the IO subsystem and the flows between all of these components. |
See which Spotlight on Oracle Edition is right for you:- Spotlight on Oracle Standard Edition
Identify and diagnose thousands of performance issues—whether it’s a specific user, resource-intensive SQL transaction, I/O bottleneck, lock wait or other exact source. Automatically set baselines, thresholds and display alerts. (Optional RAC Diagnostics available as an add-on.) - 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; and a new feature called "predictive diagnostics" which goes beyond detecting and diagnosing immediate performance problems to anticipating future performance issues before they impact the database. (Optional RAC Diagnostics available as an add-on.) - Spotlight on Oracle Xpert 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 Cluster) environments detecting performance bottlenecks from the node to the cluster level and the interconnect.
Comparison Chart of Spotlight on Oracle Editions| Features | Standard | Professional | Xpert | | Real-time Diagnostics (including Record & Playback) |  | | | | Enhanced Top SQL Drilldown | | | | | Analyze Trace | | | | | Knowledge Xpert for Oracle Administration | | | | | Troubleshooting Instances | | | | | Alert Log Reader | | | | | Diagnostics for Unix, Linux & Windows | | | | | Predictive Diagnostics | | | | | Troubleshooting Clusters | Optional Add-on | Optional Add-on | | | Diagnostics for RAC (including RAC Services) | Optional Add-on | Optional Add-on | | | SQL Optimization | Optional Add-on | Optional Add-on | |
| • | Pinpoint and resolve the source of Oracle performance issues proactively | | • | See graphical flows that illustrate the rate at which data moves between components | | • | Get alerts of potential bottlenecks via audio or visual alarm if any component begins to exceed performance thresholds | | • | Obtain drill-down details on the performance of ASM disk groups (when automatic storage management is used) | | • | View flashback performance, which is critical to backup and recovery for the Oracle 10g database |
Record & Playback | | • | Capture granular detail of an Oracle instance | | • | Extend the ability to play the instance back | | • | See information as if it were happening in real time | | • | Perform diagnostics at any given time |
| • | Get expert advice to greatly reduce time to resolution | | • | Leverage a visual tool to identify issues | | • | Follow a built-in tuning guide for efficient reference |
| • | Drill down to details about the source of a performance problem | | • | 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 |
| • | Detect cluster latency problems across the cluster hardware interconnect | | • | Measure cluster overhead caused by excessive inter-node communication | | • | Detect load-balancing problems across cluster instances based on user-definable load metrics | | • | Measure and detect problems with the Global Cache performance launch window |
| • | View an aggregate of performance data across all instances of the cluster | | • | See a consolidated view of cluster-level alarms | | • | Get extensive, context-sensitive, prescriptive advice on the Oracle database and cluster performance diagnostics | | • | View how each service is distributed across the cluster's nodes and what resources are being consumed on each |
| • | Get automatic scans identifying the problematic SQL in multiple database objects, source code files and SGA collections | | • | Optimize multiple database objects, source code files and SGA collections | | • | Automatically generate index options for individual SQL statements and groups of SQL | | • | See the effects of generating index options |
| • | See graphic displays in real time of the actual flow of data in your Solaris, AIX, HPUX, Red Hat/Linux and Windows operating systems—including memory, cache, disk storage and network | | • | Identify congested areas and quickly respond to performance problems on the physical servers |
| • | Predict the future performance for individual SQL statements on the database | | • | Use predictions to identify SQL statements whose performance may not scale adequately as data volumes and SQL execution rates increase | | • | Mitigate problematic SQL statements that can be predicted to occur before they cause widespread cost and performance issues |
| • | Drilldown provides consolidated view of SQL statements | | • | Quickly identify SQL statements consuming the most resources |
| • | View the contents of Oracle trace files in a simple graphical interface | | • | Uncover how the Oracle database is processing SQL statements and how resources are being used to execute those statements |
| • | Displays chronological list of messages and errors that occurred in the database | | • | Includes search query for quick identification of problem areas |
|