The FASTEST way to find and fix Oracle performance bottlenecksSpotlight® on OracleYour hardware budget might not be growing, but your data volume sure is. And today's economic environment puts IT cost savings front and center. What can a DBA do? Save time detecting and diagnosing performance issues in your Oracle database environment quickly to reduce downtime and IT costs.
Spotlight on Oracle enables real-time diagnostics, providing the fastest way to find and fix performance bottlenecks in Oracle and Oracle RAC database environments. Show your boss the improvements you can make to managing performance issues and the corresponding ROI with Spotlight on Oracle. 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. (RAC option available). - 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. (RAC option available). - 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 | | | | | 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 future performance of individual SQL statements that may degrade as data volume and SQL execution rates increase. | | • | Predict increases in contention that might result in database performance degradation in the future if current trends continue. |
| • | 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 |
|