Quest Performance Analysis for Oracle
Quest Performance Analysis for Oracle is a comprehensive database workload analysis tool that facilitates both real-time and historical monitoring and problem resolution. It allows DBAs to rapidly and effectively focus their attention on application and database-related performance issues, so you can solve problems quickly while improving overall application responsiveness.
Quest Performance Analysis for Oracle offers an integrated health check engine that continuously analyzes performance information to detect database behavioral anomalies and inefficiencies. The findings are delivered as concise action plans, to maximize database performance and scalability. The health check encompasses a wide range of performance issues, best practices and advanced diagnostics.
Components of Quest Performance Analysis for Oracle include:
- Performance Dashboard
- Consolidates key performance metrics
- Provides at-a-glance understanding of database health
- Enables root-cause detection
- Includes 'health check' results in the form of Performance Advisories and Best Practices
- IntelliProfile
- Adaptive database profiling technology built into the SQL Server memory sampling component of Performance Analysis known as StealthCollect™
- Continually and invisibly monitors and analyzes database performance right from the middleware
- Learns the database's signature behavior for the hour of the day, day of the week, etc.
- Determines the acceptable/normal ranges of activity, which gives comparison information needed to understand true database performance
- Performance Advisories
- Integrated, real-time database analysis used to detect a wide range of performance issues
- Offers advanced diagnostics and coherent action plans to maximize database performance and scalability
- Ensures the tuning process is both painless and efficient
- Proivdes drill-down links to the offending database occurrence and supporting evidence
- Offers optional in-context links to other Quest tools for resolving diagnosed problems
- Execution Plan History
- Tracks all changes in execution plans and retains a complete history of these changes
- Change Tracking
- Automatically tracks changes to your database and correlates the performance impacts caused by these changes
- Dimension Filtering
- Granular data filtering to ensure easy location and delivery of information when searching historical performance
- Executive Summary Report
- One-click report designed to deliver critical performance information to key decision-makers
- Comparison to Baseline Reports
- Compares database activity for a given time range to the baseline
Quest Performance Analysis for Oracle offers integration with Quest SQL Optimizer for Oracle, Benchmark Factory, and Toad for Oracle.