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)
Features
- 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.
0 comments:
Feel free to contact the admin for any suggestions and help.