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 for	Monitoring sessions, processes, tablespace capacity, and wait events
Under the hood	Grafana 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.

Oracle monitoring centers on the operational limits DBAs watch most: sessions, processes, and tablespace capacity. The integration tracks all three, plus wait events that show where time goes inside the database.

Setup is a little heavier than other integrations because it needs the Oracle Instant Client on the Alloy host. A dedicated monitoring user with specific grants is also required, which is standard practice for Oracle monitoring.

Oracle Database integration