Advanced Performance Management for Critical Oracle Databases - Performance Analysis for Oracle

Most Oracle databases today are managed by Oracle's Enterprise Manager (OEM). This is essentially a basic solution for performance management, but what about those problems that you just can't seem to resolve using Oracle's native technology? This can introduce considerable risk when managing critical databases.

Foglight Performance Analysis, extends OEM's basic management to the next level providing advanced performance management for your busiest, most critical databases. Unleash the performance potential of your Oracle databases with:

•Intelligent alerting -- detect unusual behavior with adaptive baselines to uncover deviations to normal activity for immediate attention.

•Problem centric workflow -- prioritize problems by severity of impact and provide next steps workflow to determine root cause and resolve the problem.

•Common problem recognition -- leverage weeks, months of historical data providing real-time advisories to accelerate resolution

•Exposing degrading performance trends --compare the workload from different periods to identify the relative health of overall performance

•Eliminating change impacts -- quickly pinpoint elusive changes (planned or unplanned) and realign to maximize performance


StealthCollect® – High-frequency in-memory collection provides deep session-level collection at a fraction of the overhead imposed by tracing or SQL-based collection methods.
Performance Advisories – Built-in analytics and business intelligence is like having an in-house Oracle expert to review performance data and provide customized advice to guide DBAs toward maximizing performance.
IntelliProfile® – Sophisticated baselining algorithm continually tracks database behavior and identifies activity that is outside normal deviation.
Statement-level Wait Event Analysis – Provides wait event data down to the statement level, greatly decreasing the time required to resolve resource-related performance problems.

QuickCompare – the compare utility provides DBAs with a shortcut to identifying the root cause of performance deviations in application environments. By allowing customized comparisons of any aspect of an instance or application workload with full access to baseline data, identifying the cause of performance deviations is simple, and can be automated with scheduled reporting.
ChangeTracker – Automated change tracking enables DBAs to receive notifications of changes to server, instance, database and schema environments as well as application SQL degradations and a facility to define custom change alerts. Integrated alerting allows DBAs to use the analysis history view to correlate performance slowdowns with changes to quickly understand where to focus tuning and troubleshooting initiatives.
Integrated Reporting– Built-in wizard-driven reports allow DBAs to easily define, customize, and schedule reports on system health, performance, trends, changes, and a variety of other data points. Plus, by leveraging the long-term performance repository, detailed custom reports are always just a query away. WebView – Enterprise-level visibility, administrative shortcuts, and robust alerting are available from one easy-to-use web interface. WebView provides DBAs with a centralized, configurable set of dashboards to expose performance anomalies across any monitored Oracle and SQL Server instances.
Long-term Performance Repository – Unlimited performance and environmental data storage and dimensional analysis are provided in a data warehouse. DBAs can feel confident that application trends and the custom reports created on their application workload will be available and accessible using standard SQL query techniques. Dimensional Analysis – Traditional methods of analyzing application and workload trends require DBAs to trace activity and sift through huge amounts of data. Foglight provides a dimensional drill-down that exposes resource bottlenecks from poorly written code, inefficient database accesses or rogue applications or users more efficiently.

You can download a trial version of Quest's Performance Analysis for Oracle, the below link drops you there....

http://www.quest.com/Foglight-Performance-Analysis-for-Oracle/

Regards,

Shafiulla Syed