Foglight for Oracle

Diagnose and resolve performance issues while optimizing your Oracle workloads.

Rapidly resolve database issues – before they impact performance and users.

You’re being asked to manage increasingly complex database environments, both on premises and in the cloud. You can’t sacrifice system health and performance for cost efficiency. What if you could proactively manage the health of your Oracle infrastructure and quickly diagnose and resolve performance problems, while optimizing your Oracle workload to prevent future issues?

Foglight® for Oracle can make your complex job easier by providing performance monitoring and optimization for your Oracle environment. With a single tool you can set up alerting and notification, real time and historical diagnostics and reporting all combined with unmatched analytics of collected data.

Key benefits

Global view
See the most critical issues across platforms and take immediate action.
Built-in intelligence
Understand enterprise health and activity at a glance. Get pop-up advice with correlated workflows.
Adaptive baselines
Receive alerts when activity deviates from normal metrics.
Rich historical data
Resolve issues through diagnostics and alarm data from any drill-down screen.
Drag-and-drop reporting
Use data you have collected to develop customized views and reports.
SQL workload analytics
Investigate workload by drilling into data on users, programs, SQL and sessions.
Historical lock analysis
Resolve concurrency issues with historical reviews of blocking-lock scenarios.
Automated change tracking
See changes to server, instance, database and schema environments and SQL degradations.

Supported platforms

No matter which database platforms you use, Foglight can help you monitor, predict, diagnose and resolve database performance issues quickly.

Foglight solves common DBA Challenges

Manage Multiple Platforms
Performance #1 Responsibility
Improved Resolution Time

Features

Comparison reporting

Identify the root cause of a performance deviation in your application environment.

Wait-event analysis

View wait-event data at the statement level to resolve resource-related performance problems.

Automatic instance discovery

Rapidly deploy through automated discovery of instances and specific hosts.

Alarm workflow

Search for past solutions, set up blackouts and manage your alarms.

Easy integration

Integrate your other end-to-end enterprise monitors seamlessly.

Wait-state analysis

Determine the location and cause of waits by diagnosing your wait statistics.

Wizard-driven installation

You can easily add database monitoring to your infrastructure or configure as a standalone solution.

Powerful performance investigation

Proactively optimize performance with an analytics engine that collects and investigates data on baselines, lock analysis and change tracking.

Specifications

  • Both on-premises and cloud deployments
  • Enterprise Edition
  • Standard Edition
  • Standard Edition One
  • Standard Edition 2
  • Express Edition
  • Personal Edition
  • All Operating systems supported by Oracle.

Note: SQL PI extension supports Oracle versions 11gR1 and above

    Overview

  • View the complete instance health status in a single view.

  • SQL-PI: top SQL

  • Investigate workload by drilling into top SQL then go deeper into data.

  • I/O Analysis

  • Examine top objects, files and disks I/O statistics and wait-events.

  • Change Tracking

  • Track changes and visually correlate them with the workload.

  • Compare

  • Compare configuration and performance statistics.

  • Exadata

  • Analyze storage-cells performance and receive alerts for detected issues.

  • Plan Analysis

  • View, analyze and compare executions plans for SQL statements

Award-winning database performance monitoring

See why Foglight was named “Best Database Performance Solution” in the 2018 DBTA Readers’ Choice Awards.

Resources

Foglight for Oracle
Datasheet
Foglight for Oracle
Foglight for Oracle
Manage, diagnose and optimize Oracle database performance, on premises and in the cloud.
Read Datasheet
Foglight for Oracle Overview
Foglight for Oracle Overview
Video
Foglight for Oracle Overview
Foglight for Oracle Product Overview
Watch Video
Foglight Solutions for Cross-Platform Database Performance Management
Datasheet
Foglight Solutions for Cross-Platform Database Performance Management
Foglight Solutions for Cross-Platform Database Performance Management
Manage, diagnose and optimize Oracle database performance, on premises and in the cloud.
Read Datasheet
Optimize Your Databases Using Foglight for Oracle's Performance Investigator
Technical Brief
Optimize Your Databases Using Foglight for Oracle's Performance Investigator
Optimize Your Databases Using Foglight for Oracle's Performance Investigator
The Performance Investigator feature of Foglight for Oracle helps you: • Achieve top database performance by providing comprehensive database, storage and virtualization monitoring, along with advanced workload analytics
Read Technical Brief
A Zombie's Survival Guide in a Changing Database World
E-book
A Zombie's Survival Guide in a Changing Database World
A Zombie's Survival Guide in a Changing Database World
With the rise of autonomous databases – and all the other scary changes in database management systems – you, as a DBA may be wondering whether you’re in the midst of a DBApocolypse. You are. And this is your definitive survival guide.
Read E-book
The Importance of Continuous Monitoring in a DevOps Pipeline
Technical Brief
The Importance of Continuous Monitoring in a DevOps Pipeline
The Importance of Continuous Monitoring in a DevOps Pipeline
A common challenge in many IT teams is the “blame game” where developers blame DBAs for stability and performance issues and vice versa. What if you had complete visibility and continuous monitoring to understand the root cause of database issues?
Read Technical Brief
Managing Cross-Platform Database Environments
Technical Brief
Managing Cross-Platform Database Environments
Managing Cross-Platform Database Environments
This technical brief outlines the top five complications faced by DBAs amid the rush of new database technologies in recent years. For each challenge it provides background, context and the benefits Foglight for Databases brings in addressing them.
Read Technical Brief
DBAs Face New Challenges: Trend in Database Administration
White Paper
DBAs Face New Challenges: Trend in Database Administration
DBAs Face New Challenges: Trend in Database Administration
To gain insight into the evolving challenges for DBAs, Quest commissioned DBTA to survey DBAs and those responsible for the management of the corporate data management infrastructure. The results are in and the thought-provoking findings are now available
Read White Paper

Get Started Now

Gain deep visibility into the health of all your database environments.

Support & Services

Product Support

Self-service tools will help you to install, configure and troubleshoot your product.

Support Offerings

Find the right level of support to accommodate the unique needs of your organization.

Professional Services

Search from a wide range of available service offerings delivered onsite or remote to best suit your needs.

Training & Certification

Training courses delivered through online web-based, on-site or virtual instructor-led.