OPA-PA

Public beta · Oracle 11.2+ · PostgreSQL 13+

Performance analysis for Oracle and PostgreSQL, free.

OPA-PA is a desktop performance analyzer for DBAs and developers: live activity dashboards, drill-down from a spike to the session, the SQL and its plan, and an AI assistant that reads the same data you do. Every view is a plain SQL script you can read, change and share.

OPA-PA Top Activity dashboard: average active sessions by wait class over the last hour, with the top SQL for the selected period below

What it does

Live activity, then drill down

Top Activity, system load, sessions, waits and SQL. Select a period on a chart and the tables follow; click a row to open the SQL, its plan, the session or the object.

History without add-ons

Where the database keeps no activity history, or it is licensed separately, OPA-PA samples active sessions into a local store. Export an incident's hour and a colleague opens it offline.

Scripts are the UI

Catalog, tables, charts, dashboards, actions and navigation come from SQL files with a short YAML header. Add your own next to the built-in packs; no plugins to compile.

AI assistant and MCP

Ask about what you see in a view, with your choice of provider: Anthropic, OpenAI, an OpenAI-compatible server or a local Ollama. An MCP server lets other AI tools use OPA-PA's scripts.

Safe by design

Values always go as bind variables. Actions that change anything ask for confirmation. Licensed database options are confirmed by you, and scripts that need them stay hidden otherwise.

Native clients and a worksheet

Run SQL in the built-in worksheet, or open SQL*Plus or psql already logged on to the same connection, when a terminal is the better tool.

System Load dashboard: DB time, DB CPU and host CPU over the last hour, top wait events below
System load and top wait events
AWR Activity dashboard: a week of activity by wait class with a selected period and its top wait events
A week of history, one selection away

Free, and it stays free

The application is free to use, and that will not change. Everything in the free version stays in the free version: paid licences, sponsorships and partnerships never take features away or lock existing ones.

What they do is add: extra script packs, custom branding, features built for a partner's customers, priority help. They also pay for development, so the free tool keeps getting better for everyone.

We are looking for partners

OPA-PA is developed independently. We are looking for companies that want this tool to grow and want to shape where it goes: database consultancies, support providers, vendors and teams that run many databases. Each partnership is agreed individually; these are the kinds we have in mind.

Strategic partner

Build it together

  • A say in the roadmap and in what gets built first
  • Your own branding: a co-branded or white-label build for your customers
  • Script packs and features made for your customers and services
  • Direct line to the developer, priority fixes
  • Top placement among the partners, on the site and in the application

Founding partner

Be among the first

  • A permanent founding-partner mention on the site and in the application's About
  • Early access to new builds and features
  • Influence on priorities while the product takes shape
  • Personal script packs for your team or your clients
  • Preferential terms on future licences and packages

A limited group, open during the public beta.

Gold sponsor

Support the work

  • Your name and logo among the sponsors, on the site and in the application
  • Early builds and release notes ahead of time
  • A direct channel for feedback and requests

Something else in mind, such as an engine for another database, training or a joint offering? Write to us and we will find the right shape.

sponsors@opa-pa.com

Download the beta

Portable builds: unpack and run, with Java included and nothing to install. The user guides (English, Spanish, Russian) come with the build.

The links always point to the latest beta. Found a bug or have an idea? beta@opa-pa.com