Foglight Performance Analysis for Oracle

Oracle performance tools that provide advanced management

Identify hard-to-find and complicated Oracle bottlenecks and inefficiencies.

Get the most granular information possible without running SQL Trace. This Foglight performance analysis tool continually samples Oracle’s SGA — up to 400 times per second — and automatically generates a time-sensitive baseline for every database-level metric. Understand even the most elusive and complicated bottlenecks and inefficiencies, and resolve them with built-in workflows, automated advice and pre-compiled action plans that guide you through response-time and wait-event analysis.

Features

Benefit from these features with Foglight Performance Analysis for Oracle:

  • Problem resolution – Speed time to resolution, and remove the guesswork of interpreting raw data by following built-in workflows. Receive intelligent warning alerts based on deviations from normal activity. Plus, optimize performance with context-specific expert advisories.
  • Trend analysis – Detect significant patterns in resource usage, plus identify and resolve degrading performance conditions.
  • Performance assurance – Minimize risk when upgrading your database or deploying new applications in production, and facilitate top performance for your post-change environment.
  • StealthCollect® – Reduce overhead when executing direct SQL against production, or running a trace with deep SQL-level collection and analysis.
  • Performance advisories – Maximize performance with built-in analytics and business intelligence that reviews workload data and produces customized reports.
  • IntelliProfile® – Detect abnormal activity with an advanced baselining algorithm, and track database behavior.
  • Statement-level wait-event analysis – Accelerate resolution of resource-related performance issues with wait-event data that’s down to the statement level.
  • QuickCompare – Swiftly determine the causes and symptoms of performance deviations in application environments, and take immediate action.
  • Integrated reporting – Define, customize, generate, schedule and deliver targeted, built-in reports on a variety of topics and data points – such as system health, performance, trends and changes.
  • Long-term performance repository – Benefit from dimensional analysis, as well as unlimited performance and environment data storage.
  • Automated change tracking – Get alerts about changes to server, instance, database and schema environments, as well as application SQL degradations.
  • Foglight integration – Experience a fast, easy integration with Foglight for Oracle. Get enterprise-level visibility and alerts, administrative shortcuts, customized dashboards and tailored reports from a simple-to-use web console.

Specifications

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-UXWindows
32 bit
Windows
64 bit
Windows
Itanium
8.1.7 checkmark 16px  checkmark 16px checkmark 16pxcheckmark 16px  
9.0.1checkmark 16pxcheckmark 16px  checkmark 16px checkmark 16pxcheckmark 16px  
9.2.0checkmark 16pxcheckmark 16px  checkmark 16px checkmark 16pxcheckmark 16px  
9.2.0.2checkmark 16pxcheckmark 16px  checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
9.2.0.3checkmark 16pxcheckmark 16px  checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
9.2.0.4checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
9.2.0.5checkmark 16pxcheckmark 16px  checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
9.2.0.6checkmark 16pxcheckmark 16px  checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
9.2.0.7checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
9.2.0.8checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
10.1.0.2checkmark 16pxcheckmark 16px  checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
10.1.0.3checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
10.1.0.4checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px
10.1.0.5checkmark 16pxcheckmark 16px  checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px  
10.2.0.1checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px
10.2.0.2checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px
10.2.0.3checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px
10.2.0.4checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px
10.2.0.5checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px   
11.1.0.6checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px 
11.1.0.7checkmark 16pxcheckmark 16px checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px 
11.2.0.1checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px 
11.2.0.2checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px  checkmark 16px 
11.2.0.3checkmark 16pxcheckmark 16pxcheckmark 16pxcheckmark 16px checkmark 16px  checkmark 16px 

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

Dell 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).

We periodically extends the support for new database and platform versions. For registered  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.

Resources

Screenshots

loading

Foglight Performance Analysis for Oracle (5 Screenshots)

Take a Screenshot Tour

Performance - SQL

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

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

Oracle History - Breakdown

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

Historical Workload Overview

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

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.