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.

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.

System 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 is 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)
BrowserMicrosoft 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.1, 5.2, 5.3 and 6.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 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)
                     64-bit (x64) versions 3.0, 4.0 and 5.1, 5.3 (10g and up)
  • 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
CPUAccording to the Hardware requirements document accessible through the document library.
MemoryAccording to the Hardware requirements document accessible through the document library.
Hard Disk SpaceAccording 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
Oracle InstancePerformance Analysis supports monitoring 64-bit Oracle versions only with the exception of Windows and Linux which enable 32-bit monitoring as well
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 is partially supported
    • Full Oracle Application dimensions support
    • E-business advisories are not supported
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.

Language Supported:

  • US English

Support Docs, Notes and Guides

Release Notes and User Guides back to top