Apodofos Community Edition · free and open source

See what is slowing your Oracle database, in plain English. Offline.

Apodofos Report Analyzer reads an Oracle AWR, ASH or Statspack report on your own Windows PC, shows it next to a plain-English diagnosis, and gives you a ranked plan with ready-to-run SQL. It never connects to a database and never uses the internet.

Download for Windows View source on GitHub

Version 1.0.0 · Windows 10/11 x64 · Licence AGPL-3.0-only · Installer and portable zip

Apodofos Report Analyzer showing an AWR report on the left and, on the right, a health score with key numbers and a Fix first plan, in dark theme.
The Summary tab: health score, key numbers and the Fix first plan next to the original AWR report (synthetic sample).

Built for the person who has to explain the report

Plain English, side by side

Every finding says what is wrong, why it matters and what to do, in words a non-DBA can follow. A technical view is one click away for DBAs. The original report stays next to it, with jump-to-section links.

A Fix first plan

Actions ranked by expected payoff, with impact, effort, risk and confidence, so you know where to start instead of facing a wall of numbers.

Ready-to-run SQL

Valid Oracle 19c SQL for tuning tasks, plan baselines, index, redo and memory checks, each with cautions and a link to the matching Oracle documentation.

Offline and private

Runs entirely on your computer. No account, no telemetry, no update check, no upload. Your report never leaves your machine.

How it works

  1. Open a report

    Drop or open an AWR, ASH or Statspack report (HTML or text). The type is detected from the content, and you can override it.

  2. Read the findings

    Get a health score, key numbers, charts and findings in plain English, side by side with the original report.

  3. Fix with ready-to-run SQL

    Follow the Fix first plan, copy the SQL you need, review it, and test it outside production.

See it in action

Real screenshots of the desktop app analysing the synthetic sample reports that ship with the project, in light and dark themes. Select an image to see it full size.

Supported reports

Supported report types, formats and notes
ReportFormatsOracle versionsNotes
AWRHTML, text11g to 19c+Layouts from 11g to 19c are parsed; the rules are calibrated for 19c. Older releases get a note.
ASHHTML, text19c+ashrpt output: activity by event, SQL, session, module and time slice.
StatspackText10g-style and 19c-style layoutsMapped onto the same rules as AWR where an equivalent exists.

Honest limits

  • Text ASH and 12c+ Statspack layouts are inferred from the documented structure and from synthetic fixtures; they are not validated on a broad set of real customer reports. Missing sections produce warnings, never crashes.
  • A report is a static snapshot: the tool cannot see anything the report does not contain.
  • Thresholds are general guidance, not a substitute for knowing your workload. Treat low-confidence findings as questions to check.
  • The desktop app is Windows only. The HTML export opens in any modern browser.

Privacy by design: runs offline, no data collected

Apodofos Community Edition does not collect, transmit, sell or share any data. There is no telemetry, no analytics, no account or licence check and no update check. The interface loads no fonts, scripts or images from the internet and blocks navigation to any other address.

This website follows the same rule: no cookies, no analytics, no trackers and no requests to other servers.

Read the privacy notice

  • Your reports are analysed on your computer and kept in memory only while the app is open.
  • Reports are treated as untrusted input: scripts are removed and the report is shown in a sandboxed frame.
  • Settings (window size, five recent file names, theme) stay in %LOCALAPPDATA%\Apodofos.
  • Reports can contain host names, schema names and SQL text: review exports before you share them.

Why you can trust the result, and when not to

Confidence on every finding

Each finding is rated High, Medium or Low with a plain reason. Related findings are grouped by root cause, so one problem is not counted five times.

Data quality checks

A very short window, an idle database, a truncated report or impossible values are detected. The health score then says not reliable instead of showing a misleading grade.

Fix first plan

Actions are ranked by expected payoff, with impact, effort, risk and confidence, so the first step is the one most likely to pay off.

Documentation catalogue

Findings link to the relevant Oracle Database 19c documentation. The catalogue (over 500 entries, with short summaries in our own words) ships inside the app; opening a link is your choice, and the app makes no request itself.

How it works in detail: Reliability: how much can you trust a result · Documentation

Frequently asked questions

Is it free?

Yes. Apodofos Community Edition is free software under the GNU AGPL v3 (AGPL-3.0-only), with no registration, no trial period and no licence key.

Does it need internet access?

No. It never connects to a database or to the internet. You only need internet to download it, and to open the Oracle documentation links if you choose to.

Which Oracle versions are supported?

AWR layouts from 11g to 19c and later are parsed, and the rules are calibrated for 19c. ASH and Statspack are supported as described in the table above, including the limits for layouts we could only infer.

Do I need Oracle licences?

Apodofos itself only reads a file you give it. But AWR, ASH and ADDM are part of the Oracle Diagnostics Pack, and SQL Tuning Advisor is part of the Tuning Pack. Some of the generated SQL queries views that need those packs, and each such snippet carries a caution. Check your own licence entitlement (see the Oracle Database Licensing Information User Manual) before running anything, and test every change outside production.

Is my report uploaded anywhere?

No. The analysis happens on your computer and nothing is sent anywhere. Reports may contain sensitive names and SQL text, so check any HTML export or SQL script before you share it, and never attach real reports to a public issue.

Windows says the installer is unsigned. Is that normal?

Yes. The files are not code-signed, so Microsoft Defender SmartScreen may show “Windows protected your PC” or “Unknown publisher”. Download only from the official GitHub release, verify the SHA-256 checksum on the download page, then choose “More info” and “Run anyway” if the hash matches.

What is WebView2?

The app shows its interface with the Microsoft Edge WebView2 Runtime, a Microsoft component included with Windows 11 and Microsoft Edge. On a Windows 10 PC without it, the installer stops and explains how to install it manually. Apodofos never downloads it for you.

How do I uninstall it?

Installed with the MSI: Settings, Apps, Apodofos Report Analyzer, Uninstall. Portable zip: delete the folder. Your settings stay in %LOCALAPPDATA%\Apodofos until you delete that folder yourself.

How do I report a bug?

Open an issue on GitHub. Describe what happened and which report type you used, but do not attach real reports, host names, schema names or SQL text. Security problems: see the security policy.

About the Professional Edition

Apodofos Community Edition is the free, open-source edition. A separate commercial Apodofos Professional Edition is planned, with more analyses and support for other databases. It is not available yet and nothing on this site is an offer. If you are interested, say so by opening an issue on GitHub.

Try it on a report you already have

Download for Windows View source on GitHub

Why Apodofos?

ΑπόδοσηApodosiperformance
ΦωςFoslight
Apodo + Fos = Apodofos
Light of Performance (φως απόδοσης)

Apodofos throws light on the performance of your database: it turns a dense report into something you can read and act on.

Pronunciation: a-PO-do-fos