Fast Database Performance Analysis and Problem Diagnosis
Performance Explorer-i delivers rapid performance analysis and diagnosis of performance problems in production databases. Its comprehensive reports, utilities and models utilize patented analytics to bring unprecedented speed, precision and scope to the analysis task, with negligible impact on the systems being analyzed.
Database Problem Diagnosis
Performance spike analysis
Identify areas of performance spikes and degradations using patented analysis technology that reduces analysis time from hours or days to less than a minute.
Change impact analysis
Detailed change impact analysis on cause of performance and availability problems with immediate drilldown into detailed information.
Oracle RAC analysis
Visualize performance metrics across multiple databases or multiple nodes of a RAC cluster. Access DLM statistics, RAC system statistics, or RAC latch information with a single click.SQL impact analysis
Pinpoint problematic SQL using Advanced Top SQL Search enforced with DML and SQL pattern search filters. Drill Down to the level of individual SQL queries to determine how a change in different SQL characteristics is affecting the system. Similar queries can be aggregated to display cumulated impact on system performance.
Fast navigation of critical performance metrics
Navigate summary and detail information on system statistics, wait events, latches, SQL and other performance data efficiently and effectively. Eliminate painful eyeballing across Statspack and AWR reports when time to resolution is critical.
Cross-database analysis
Analyze heterogeneous database environments with built-in support for multiple commercial database systems and multiple versions of the same commercial DBMS. Perform problem and root cause analysis across multiple instances or multiple databases.
High performance visualization
Visualize tens of thousands of data points in a few seconds. Instantly superimpose current and historical time periods to identify seasonal performance patterns and more.
Integrated trending and forecasting
Clearly identify trends in database performance with smoothing (averaging) filters and linear regression models. Use trending projections to facilitate capacity planning.