Features and Benefits

Quest Performance Analysis for Oracle

• Provides an “in-house Oracle expert,” yielding targeted, insightful advice rivaling that of an expensive Oracle consultant
• Many performance problems are caused by changes to your database.  Performance Analysis automatically tracks changes and correlates the performance impacts.
• Offers a comprehensive, easy-to-understand view of your environment by presenting dozens of performance metrics in a concise, business-friendly report
• Creates an action plan based on your application requirements
• Analyzes any database in your environment and provides explicit tuning advice
• Offers customized advice for tuning your environment based on workload, configuration and applications
• Security exposure checks
• Provides historical reports, both online and in HTML, showing instance activity, memory usage, configuration, file IO, latching, reorganization need and more
• Continues the workflow from diagnosis to resolution with embedded integration to Quest tools for SQL tuning and space management
• Provides configuration recommendations for your RAC environment
• Identifies and anticipates performance issues and eases time to resolution
• Increases DBA efficiency by automating reports
• Provides a central repository for retrieving all performance-related statistics
• Offers intelligent and customizable performance and activity highlights for alarming and drilldown to related problems
• Captures performance data without impacting database performance
• Performs root cause analysis: Rapidly identify bottlenecks, anomalies, peak activities, and application performance trends
• Contains a visually-oriented GUI, zooming feature, and drilldown to allow DBAs to quickly focus on top resource consumers by various dimensions, such as SQL statements, users, programs, machines and many more
• Allows users to monitor current Oracle database instance and session activity and performance consumption at a glance
• Offers full diagnostic support for database locking in both recent and historical collections.
• Captures all SQL statements and performance metrics non-intrusively at sub-second intervals, with no overhead to Oracle
• Identifies the root of most performance problems by detecting offensive SQL statements
• Provides immediate troubleshooting in real-time, even when Oracle is overloaded or not responding
• Unmatched deep visibility of RAC systems activity and workload
• Provides SQL, user, and program for ERP transactions