Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »

Foglight Performance Suite for Oracle

Oracle Monitoring, Diagnostics, and Advanced Workload Analysis

This complete Oracle performance management solution constantly monitors environment health, accelerates problem resolution, simplifies workload trend analysis, and delivers targeted custom reports – all from an easy-to-use web console. The Foglight Performance Suite enables you to resolve issues before they impact users and makes your job easier by extending the capabilities of basic database monitoring software like Oracle Enterprise Manager. Plus, it greatly reduces the risks associated with database vulnerability, performance bottlenecks, upgrades, patches, and more. With the Foglight Performance Suite, you’ll work smarter, not harder – and maximize your Oracle database resources.

Features

Global View – Determine your most critical instance alarms and immediately take action to resolve performance issues, both for Oracle and across other database platforms.

Built-In Intelligence – Understand the health and activity of your Oracle enterprise with a variety of integrated management and performance views as well as pop-up advice with correlated workflows.

Adaptive Baselines – Track performance using automatic detection and calculation of normal ranges for all metrics, and receive alerts about deviations from normal activity.

Accelerate Problem Resolution — Receive only intelligent warning alerts based on deviations from normal activity. Follow built-in workflows that speed time to resolution and take the guesswork out of interpreting raw data. Optimize performance using context-specific expert advisories.

Prevent Problems and Analyze Trends — Discover and correct degrading performance conditions. Identify significant patterns in resource usage.

Validate Performance during Change — Ensure peak performance for your post-change environment and minimize risk when upgrading your database or deploying new applications. 

Wizard-Driven Installation – Use a powerful wizard to easily install and configure Foglight as a standalone solution or to add Oracle monitoring to your existing infrastructure.

Automatic Instance Discovery – Deploy Foglight capabilities rapidly and painlessly with automatic instance discovery or specific hosts. Manually add instances as needed.

Monitor RAC, ASM and Dataguard – Receive global alerts for issues detected at the cluster or instance levels, plus notification on cluster overhead and interconnect problems. Monitor failover replication and manage storage efficiently. 

Alarm Workflow – Manage and annotate alarms, set up blackouts, and search for past solutions.

Rich Historical Data – Navigate easily through performance diagnostics and alarm data to resolve recent performance issues from any drill-down screen.

Integrated Reporting – Provides targeted, built-in reports. With easy-to-use wizards, you can define, customize, generate, schedule, and deliver reports on system health, performance, trends, changes, and a variety of other topics and data points.

Wait-State Analysis – Diagnose wait statistics to easily determine where waits are occurring and what is causing the event.

StealthCollect® – Delivers deep SQL-level collection and analysis at a fraction of the overhead of running a trace or executing direct SQL against production.

Performance Advisories – Reviews workload data and produces custom reports to maximize performance through built-in analytics and business intelligence.

QuickCompare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.

Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in an Oracle database.

Automated Change Tracking – Identifies and sends notifications of changes to server, instance, database, schema environments, and application SQL degradations.

Easy Integration – Integrate Foglight Database Performance Suite for Oracle seamlessly with other end-to-end enterprise monitors.

Sys Reqs

System Requirements

Oracle ExaData Ready


Foglight Performance Analysis for SQL Server is Oracle Exadata and SPARC SuperCluster Ready!

Foglight Performance Suite for Oracle is comprised of Foglight for Oracle and Foglight Performance Analysis for Oracle.

Hardware Requirements

Consult with the Foglight System Requirements and Platform Support Guide to determine your hardware considerations.
It is recommended that customers running large deployments (that is, with more than 50 Oracle instances) should consult with the Foglight for Oracle Managing Oracle Database Systems - Hardware Sizing Guide.

Supported Platforms

The operating system platforms and Oracle versions supported by the Oracle cartridge are:

Oracle Version
  • 9.2.0.1
  • 9.2.0.2
  • 9.2.0.3
  • 9.2.0.4
  • 9.2.0.5
  • 9.2.0.6
  • 9.2.0.7
  • 9.2.0.8
  • 10.1.0.5
  • 10.2.0.1
  • 10.2.0.2
  • 10.2.0.3
  • 10.2.0.4
  • 11.1.0.6
  • 11.1.0.7
  • 11G R2

Note: Quest Software also supports Foglight for Oracle on Oracle Exadata Database Machine and SPARC SuperCluster.

Language Supported:

  • US English

Screenshots

Global View

See the operational health and performance of all database servers, regardless of platform, from a single view. Gain enterprise-level insight into your database environments. Foglight unifies all your databases in a centralized console to deliver consistent data and reports; this significantly increases administrative efficiency.

Home Page – Instance View

In a single view, you can see real-time and historical performance at a glance.

Custom Dashboard

Easily create customized dashboards and reports through a simple "drag and drop" interface. Extend visibility of database health and metric data to other areas of the business, including executive management, application development, and storage administrators. Most monitoring solutions require end users to view data in a specific, vendor-supplied mechanism. Foglight offers extensive dashboard and report customization that allows each customer to view real-time and historical data according to their unique requirements.

Performance - SQL

At a glance, get visibility into all the SQL running in your environment to pinpoint troublesome queries and poorly performing applications.

Oracle Performance Dimensions

Evaluate resource consumption of total SQL workload analyzed by multiple dimensions, including specific programs and OS users.

Performance History Summary

Identify instance workload, including information on which resources are being used, information on host health, and baseline indicators to identify if the activity displayed is normal for the time period.

Oracle History - Breakdown

Provides historical overview with key performance indicators for any selected time period.

Historical Workload Overview

Offers built-in business intelligence without the need to build or maintain data cubes. With correlated baseline information to identify normal instance activity and in-context advisory indicators, DBAs can find the root cause of performance issues and resolve them with ease.

Workload - Real-Time

Gain a deeper understanding of normal utilization levels and baseline ranges to improve alerting and diagnose problems caused by resource deviation. Armed with the immediate knowledge that a system is, or is not, behaving the way it usually does helps prove whether the database is the root cause of a performance issue.