The FASTEST way to find and fix Oracle performance bottlenecksSpotlight® on Oracle Standard, RAC and Xpert EditionsThere is an explosion of data today, and performance bottlenecks impact your organization. You need a solution to identify, diagnose and resolve performance problems quickly. Spotlight on Oracle enables real-time diagnostics, providing the fastest way to find and fix performance bottlenecks in your Oracle database environment. Key Benefits- Discover hard-to-find bottlenecks that comprise up to 80% of performance issues
- Eliminate guesswork in identifying and fixing problems 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
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. - Spotlight on Oracle RAC Edition
Get all of the Standard Edition’s capabilities plus the ability to look inside your Oracle RAC (Real Application Cluster) environment. Get real-time diagnostics and visual alerts on performance bottlenecks from the node to the cluster level and the interconnect. - Spotlight on Oracle Xpert Edition
Get all of the capabilities from the Standard and RAC Editions, plus additional functionality including: automated SQL tuning to maximize SQL performance; OS diagnostics to quickly correct performance problems in Linux, Unix and Windows; and predictive diagnostics providing prediction of future performance for individual SQL statements on the database.
Comparison Chart of Spotlight on Oracle Editions| Features | Standard | RAC | Xpert | | Real-time diagnostics |  | | | | Record and playback | | | | | Knowledge Xpert for Oracle Administration | | | | | Troubleshooting instances | | | | | Troubleshooting clusters | | | | | Diagnostics for RAC infrastructure | | | | | SQL optimization | | | | | Diagnostics for OS | | | | | Predictive Diagnostics | | | |
- 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
|
- 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
|
- Leverage a fully- automated approach to maximizing SQL performance
- Eliminate the manual, time-intensive process of ensuring that SQL code performs as fast as possible
- 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
- Generate stored procedure scripts for implementing changes to the SQL within these objects
- 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
|
|