Notice: will be retired soon. Please visit our new site at

White Paper

Learn the best methods for successfully managing your complex cross-platform database environments.

Read now »

Quest Community
Connect with experts, discuss the latest issues, help shape the products you care about, and much more!
Join now »

Foglight for Oracle

Scalable, Web-Based, 24x7 Database Monitoring

No other Oracle database monitoring tool has the power to accelerate problem resolution like Foglight® for Oracle. It provides constant remote database monitoring and correlates performance data from across your technology stack. And it makes your job easier by extending the capabilities of basic database monitoring software like Oracle Enterprise Manager. It guides you through response-time and wait-event analyses, so you instantly understand existing and developing database performance conditions. Plus, our IntelliProfile™ technology ensures your post-change database environment is thriving to help eliminate deployment risks. Foglight for Oracle empowers you to take action immediately and maximize your Oracle database resources.


  • 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.
  • Automatic Instance Discovery – Deploy Foglight capabilities rapidly and painlessly with automatic instance discovery or specific hosts. Manually add instances as needed.
  • Rich Historical Data – Navigate easily through performance diagnostics and alarm data to resolve recent performance issues from any drill-down screen.
  • 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.
  • Easy Integration – Integrate Foglight for Oracle seamlessly with other end-to-end enterprise monitors.
  • Wait-State Analysis – Diagnose wait statistics to easily determine where waits are occurring and what is causing the event.
  • 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.
  • Drag-and-Drop Reporting – Create custom views and reports using the data collected by Foglight.

Sys Reqs

System Requirements

Oracle ExaData Ready

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

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:

Operating System Oracle Version
AIX 5.1, 5.2, 5.3, and 6.1
  • 11G R2
HP-UX 11, 11i, 11i v2
Red-Hat and SUSE operating systems running Linux 2.4 and 2.6 kernels
ReSolaris 8, 9 & 10

Oracle Linux 5.5

Oracle Solaris 11

Windows 2000, 2003, 2008 (32-bit)
Windows 2000, 2003, 2008 (64-bit Opteron and Xeon)
Windows 2003 (Itanium)



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

Language Supported:

  • US English
Foglight for Oracle collects performance information directly from Oracle system tables and does not make use of any licensed OEM functionality such as AWR, ASH, or ADDM.



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.