Product Demo
View this webcast to learn how Foglight® Performance Analysis can solve common database challenges.
Watch demo »
Quest Community
Connect with experts, discuss the latest issues, help shape the products you care about, and much more!
Join now »
Five Minute
How-to Videos
Get even more value from Foglight® Performance Analysis with the expert tricks and tips provided in these quick how-to videos.
Watch videos »

White Paper

Read this eye-opening white paper to learn easy shortcuts for proactively overcoming database management challenges.

Read now »

Foglight Performance Analysis for Oracle

Advanced Performance Management for Critical Oracle Databases

Foglight® Performance Analysis for Oracle delivers the most granular information possible without running SQL Trace. It constantly samples Oracle’s SGA — up to 400 times per second — and automatically compiles a time-sensitive baseline for every database-level metric. Our Oracle workload analysis tool reveals even the most elusive and complicated bottlenecks and inefficiencies. Built-in workflows, automated advice, and pre-compiled action plans guide you through response-time and wait-event analysis. So you can quickly understand existing or developing conditions and how to resolve them.

Features

Foglight Performance Analysis for Oracle makes it easy to:

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.  

  • 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.
  • IntelliProfile® – Tracks database behavior and identifies abnormal activity with a sophisticated baselining algorithm.
  • Statement-Level Wait-Event Analysis – Reveals wait-event data down to the statement level, speeding resolution of resource-related performance problems.
  • QuickCompare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.
  • 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.
  • 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.
  • Foglight Integration – Integrates with Foglight for Oracle for enterprise-level visibility and alerting, administrative shortcuts, custom dashboards and reports — all from one easy-to-use web console.

Sys Reqs

System Requirements

Oracle ExaData Ready


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

Before installing Foglight Performance Analysis 7.0, ensure your system meets the following minimum hardware and software requirements:

Client Requirements

PlatformPentium III (Pentium IV recommended) or compatible processor
MemoryDedicated Client: 512 MB of RAM minimum
Shared Client: 1024 MB of RAM minimum
Note: The memory required may vary based on the following:
  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Hard Disk Space450 MB of disk space required for a full installation, which includes 200 MB download of temporary setup files that can be removed at the completion of the installation.

Notes:

  • The disk space required may vary based on options selected for installation
  • Database files extracted from a backup require additional storage space depending on the size of the database
MonitorVGA with a minimum resolution of 1024x768, small fonts
PrinterOptional for printing graphs and reports
MouseRequired for accessing all features
CD drive or Internet connectionRequired for installation only
Oracle Client A 32-bit Oracle Client Version 8i and above.
Note: Oracle Instant Client and 64-bit Oracle Clients are not supported
Operating System
  • Windows 2000 (SP3 or later)
  • Windows XP (SP1 and SP2)
  • Windows 2003 (R1 and R2)
  • Vista (Business/Enterprise)
  • Windows 7
  • Windows 2008 (up to R2)
  • Oracle Linux 5.5
  • Oracle Solaris 11

* Note: only 32-bit environments are supported for client installations

Browser

Microsoft Internet Explorer 6.0 or later

Citrix Support
  • Platform Level - MetaFrame XP 1.0 Server for Windows
  • Feature Release - MetaFrame XP 1.0, Feature Release 1 through 4

Server Requirements

UNIX/Linux PlatformsUNIX
  • IBM AIX 64-bit versions 5.2, 5.3, 6.1, and 7.1
  • HP-UX 64-bit versions 11.11, 11.23 and 11.3
    64-bit Itanium version 11.23 and 11.3
  • Sun Solaris SPARC (64-bit) versions 2.8, 2.9 and 2.10
  • Sun Solaris x64 version 2.10

Linux

  • RedHat AS 32-bit versions 2.1, 3.0, 4.0 and 5.0 (10g and up)
  • RedHat AS 64-bit (x64) versions :3.0, 4.0 and 5.1, 5.3 (10g and up), 5.5, 5.6 (unbreakable Linux), 5.7
  • RedHat 32-bit versions 8.0 (with application of the glibc-2.3.2-4.80.8 or later patch) and 9.0
  • SUSE 32-bit versions 8 and 9
    64-bit (x64) versions 9, 10 and 11
CPU

According to the Hardware requirements document accessible through the document library.

Memory

According to the Hardware requirements document accessible through the document library.

Hard Disk Space

According to the Hardware requirements document accessible through the document library.

Windows platforms and operating system
  • Windows platforms
    • Intel X86 machines
    • Intel X64 machines
    • Itanium machines
  • Windows operating systems
    • Windows 2000
    • Windows XP (up through SP2)
    • Windows 2003

    • Windows 2008 (up to R2)

Oracle InstanceFoglight Performance Analysis supports monitoring 64-bit Oracle versions only with the exception of Windows and Linux which enable 32-bit monitoring as well

Starting from Oracle version 11G, the AMM mechanism is supported when used on the supported Linux flavors
Oracle ExadataFoglight Performance Analysis is fully tolerant of Oracle Exadata
CD/DVD drive or Internet connectionRequired for installation only
PeopleSoft Versions8.0 or later
Oracle Applications Versions
  • 11.0.x
  • 11i or later (11.5.5 or later for E-Business advisories)
  • R12
Performance RepositoryOracle version 9i or later with bitmap indexes supported. Customers who wish to run the Performance Repository on Oracle Database Standard Edition should refer to the Repository_Installation_on_Oracle_Standard_Edition.pdf document, on support link.

The Performance Repository requires an Oracle database configured to 8K block size


Supported Platform Matrix

Platform/
Oracle Version
AIXSolaris
SPARC (64-bit)
Solaris
Intel/AMD
(64-bit)
Linux
64 bit
Linux
32 bit
HP-UX
Itanium
HP-UX
Windows
32 bit
Windows
64 bit
Windows
Itanium
8.1.7
9.0.1
9.2.0
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.2
10.1.0.3
10.1.0.4
10.1.0.5
10.2.0.1
10.2.0.2
10.2.0.3
10.2.0.4
10.2.0.5
11.1.0.6
11.1.0.7
11.2.0.1
11.2.0.2
11.2.0.3

Note: As of Foglight Performance Analysis version 6.5, Linux Itanium is no longer supported.

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

Support for Oracle version 11g on Linux 32-bit requires ES/AS 4 (update 3 or higher, Nahant 3).

Quest Software periodically extends the support for new database and platform versions. For registered Quest SupportLink users, click here to view and download the latest support patch updates.

Performance Repository Requirements

Foglight Performance Analysis requires 2.5GB of free disk space on the repository host in order to create the repository database – 2GB for data files and 512MB for transaction log files. An additional allocation of 2GB of free space is required for each additional instance that is attached to this Performance Repository.

Videos

Screenshots

Performance - SQL

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

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.

Docs