Grafana Learn
Sign in Sign up
Section 2 · Choose and set up an integration

Monitoring Oracle Database

Estimated time: 1 min

Oracle Database integration

The Oracle Database integration provides operational monitoring for Oracle, covering sessions, processes, tablespace usage, and wait events. Oracle monitoring centers on the operational limits DBAs watch most, sessions, processes, and tablespace capacity, plus the wait events that reveal where time goes inside the database.

What it’s forMonitoring sessions, processes, tablespace capacity, and wait events
Under the hoodGrafana Alloy’s built-in OracleDB exporter scrapes metrics using Oracle Instant Client

Metrics collected

  • Sessions and processes: Active sessions, process counts, and how close they are to configured limits
  • Tablespace: Used versus allocated space across tablespaces
  • Wait events: Which categories of waits consume time inside the database
  • Resource limits: Current values against v$resource_limit thresholds
  • Availability: oracledb_up for at-a-glance health

What to know

This integration offers:

  • Prebuilt dashboards: overview, logs
  • Prebuilt alerts: session limit, process limit, tablespace capacity

Prerequisites:

  • Requires Oracle Instant Client on the Alloy host with ORACLE_HOME set (Alloy 1.9.0+)
  • Requires a dedicated Oracle monitoring user with specific grants

Documentation

View the Oracle Database integration documentation.