Foglight Performance Analysis for OracleFeatures & Benefits | 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. |
-
-
Additional ResourcesRelated SolutionsNext Steps
|