For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Foglight for Oracle

Diagnose and resolve Oracle performance issues with monitoring software. With Foglight® for Oracle, you get unrivaled performance information and advanced Oracle monitoring to prevent costly downtime. This monitoring software provides alerting and notifications, real-time and historical diagnostics, as well as reporting, plus unmatched analytics of collected data. Take Oracle monitoring to the next level with Foglight for Oracle.

Foglight for Oracle
Foglight for Oracle ensures the health of your Oracle database environment 02:19

Proactively diagnose and resolve Oracle database performance issues.

Oracle monitoring – sounds simple, right? Not without the right monitoring tools. When you’re managing increasingly complex database environments, both on-premises and in the cloud, it’s hard to keep up. What if you could easily get the information you need to improve Oracle monitoring and tuning? This would mean you could proactively manage the health and performance of your Oracle databases, quickly resolving issues before end users could be affected.

Key benefits

Global view

Gain increased visibility for more effective Oracle monitoring. See critical issues across platforms and take action.

Built-in intelligence

Understand enterprise health and activity at a glance using monitoring software. Get pop-up advice with correlated workflows.

Adaptive baselines

Use monitoring tools to set and 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 offers comprehensive support for cloud databases - including: Amazon RDS, Azure SQL DB (single/elastic pools), Azure SQL Managed Instance and more.

Foglight solves common DBA challenges

68%

Manage Multiple Platforms

72%

Performance #1 Responsibility

75%

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

  • 10g (SQL PI for Oracle does not support 10g)
  • 11g
  • 12c
  • 18c
  • 19c

    Both on-premises and cloud deployments - including:

    • Amazon:
      • IaaS -EC2 - *Windows and Linux
      • Oracle RDS
    • Azure
      • IaaS - *Windows and Linux
  • 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

Tour

Overview
SQL-PI: top SQL
I/O Analysis
Change Tracking
Compare
Exadata
Plan Analysis
Easily manage multiple databases
Overview

Overview

View the complete instance health status in a single view.

Resources

Video

Foglight for Oracle Overview

Foglight for Oracle Product Overview
Datasheet

Foglight Solutions for Cross-Platform Database Performance Management

Manage, diagnose and optimize Oracle database performance, on premises and in the cloud.
Technical Brief

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...
E-book

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...
Technical Brief

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...
Technical Brief

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....
White Paper

DBAs Face New Challenges: Trends in Database Administration

To gain insight into the evolving challenges for DBAs, Quest commissioned DBTA to survey DBAs and those responsible for the management...
Technical Brief

Why Quest Foglight is the Right Database Monitoring Solution for Your Business

Digital transformations are everywhere, and so are associated challenges. Foglight® for Databases by Quest is the best choice for...

Get started now

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

Support and 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.

Education Services

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