UpBeat Explorer-i for Optimal Oracle Cloud Production Performance

Database Problem Diagnosis

• Performance spike analysis

  Oracle database diagnostics identify areas of performance outliers and degradations using patented analysis technology that reduces analysis time from hours and days to the sub-minute timeframe.

• Change impact analysis

  Detailed change impact analysis of the root causes of the performance and availability degradations with immediate drill-down into the specific root-cause sections.

• 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.

• Oracle ADG DataGuard analysis

  Database performance analyzer for Oracle enables root cause analysis of DataGuard performance using DataGuard Statspack on ADG Standbys. Analyze data replication performance and bottlenecks.

• SQL impact analysis / Identification of the most optimal candidates for the Oracle SQL Tuning

  Pinpoint complex 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 affects the system. Similar queries can be aggregated to display the 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 the 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 various instances or different databases.

• High-performance visualization

  Visualize tens of thousands of data points in a few seconds. Instantly superimpose current and historical periods to identify seasonal performance patterns and more.

• Integrated trending and forecasting

  Identify trends in database performance with smoothing (averaging) filters and linear regression models. Use trending projections to facilitate capacity planning.

• Batch analysis generation

  Run analysis in batch and parallel across hundreds of databases.

Database Problem Reporting

• Database Performance Overview

  Gain a single-page view of the most critical database performance metrics. Use the historical data overlay to discover changes in database performance through visual inspection immediately.

• Current Database Change Profile

  Accelerate your change root cause analysis with this report highlighting recent changes made to the database that may be affecting performance. Performance Explorer-i detects changes from new code deployments and upgrades – official or otherwise.

• Real-time Database Check

  Determine immediate threats to database stability and potential performance bottlenecks. View excessive active sessions, latch connections, RAC-related resource contention, slow I/O (for random and sequential data access), and extreme query parallelism in the database.

• Snapshot Change Analysis

  Gain a holistic view of all changes that occurred over a specific period, including changes in SQL statistics, newly introduced SQL, changed SQL plans, system statistics, wait events, latches, etc. Customize change reports by selecting time intervals for snapshot and baseline, change thresholds, and report details. Create a library of customized snapshots for fast, single-click generation.

• Visual Root Cause Analysis

  Find performance problems quickly using your eyes. View graphical representations of changes in key database metrics, including system statistics, wait events, latches, enqueues, segment I/O, datafile I/O, “Undo” tablespace I/O, rollback segments I/O, dictionary cache, library cache, and customer user SQL.

• Batch Report Generation

  Instantly generate HTML graphical reports using ChartBag Reporting Module. Report Templates can be saved and run in batch mode for continuous web publishing.