Harry – Database Activity History for Oracle Database (DAH)

Harry – Database Activity History for Oracle Database

Harry's Database Activity History (DAH) dashboard provides an AAS-style historical view of Oracle Database activity using session samples collected by Harry Performance Scraper for Oracle Database.

Harry continuously collects Oracle performance data and stores it in PostgreSQL. Grafana queries that PostgreSQL repository directly.

This dashboard does not connect directly to Oracle Database.

What this dashboard shows

• Average active sessions by wait class
• Top SQL by active time
• Top sessions
• SQL_ID activity over time
• Recent activity samples
• Top wait events
• Activity by module and program

The default time range is 30 minutes, with a 15-second dashboard refresh interval.

Requirements

• A running Harry installation collecting database activity
• Oracle Database 19c or newer
• PostgreSQL 14 or newer
• A Grafana PostgreSQL data source connected to Harry's repository
• SELECT access to Harry's PostgreSQL tables

The primary table used by this dashboard is:

oracle_database_activity_samples

Installation

1. Install and configure Harry.
2. Configure a PostgreSQL data source in Grafana pointing to the same repository used by Harry.
3. Import this dashboard from Grafana.com.
4. Select the PostgreSQL data source connected to Harry's repository.
5. Select a Source Database and an Activity Source from the dashboard variables.

The PostgreSQL data source can have any name. It is selected during dashboard import.

Activity sources and Oracle Diagnostics Pack

The default SESSION activity source is collected from GV$SESSION and does not query Oracle Active Session History.

The ASH activity source appears only when Harry has been explicitly configured to query GV$ACTIVE_SESSION_HISTORY. Enabling that collector requires the operator to verify the applicable Oracle Diagnostics Pack licensing.

Migrated historical data may also appear under the LEGACY activity source.

Resources

• Project website
• Interactive live demo
• Documentation
• Grafana dashboard documentation
• Source code and issue tracking

Support and contributions

Harry is open source and can be deployed and operated independently. Bug reports, feedback and pull requests are welcome through GitHub.

Harry is developed by Jorge Holgado and commercially supported by OneClickDBA. Professional services are available for architecture, sizing, deployment, upgrades, troubleshooting and dashboard customization.

Oracle and Oracle Database are trademarks or registered trademarks of Oracle and/or its affiliates. Harry is an independent project and is not affiliated with, endorsed by or sponsored by Oracle.