A Free Oracle Performance Tool AMON


This is a main page of AMON, the free interactive tool for performance monitoring of Oracle databases.

The tool is written completely in C using Oracle OCI API and UNIX Curses library. This allows AMON to run on every UNIX terminal. After downloading the tool, you can immediately start to use it, if the environment variables (ORACLE_HOME, PATH, LD_LIBRARY_PATH, ORACLE_SID) are set correctly. (If SQL*Plus can run, then AMON should execute as well.)

The tool executes only SELECT statements, so that you can easily test it on any database.

Why shall I use this tool additionally to Grid Control, SQL Developer or Toad? The answers could be:

  1. Sometimes you have got only a UNIX terminal (like a PUTTY window). This could be a case, if only the SSH port is allowed or if you work over VPN connection.
  2. You are comfortable with the Oracle dynamic views. You could of course just use SQL*Plus. But it's easier to monitor the changing information with AMON, because the tool already calculates the delta values and refreshes the window automatically.
  3. You are already using a UNIX terminal for your work. If you want to check some information, it's faster to use AMON and check, for instance, a hanging session or the wait events instead of starting a GUI or a browser.

This tool is developed by Andrej Simon, Oracle Germany in my free time. If you have any questions or comments, please contact me directly (andrej.simon@oracle.com).


Version history

  • Version 1.14.4 (30-Aug-2020)
    Added support for Grafana. The "-t baseline" can be used to generate AMON report in JSON format. This report can be imported into the MySQL database. Avaiable Grafana dashboards can visualize the imported data. See more details here: GitHub amon2agraf
    Posted Aug 30, 2020, 6:39 AM by Andrej Simon
  • Version 1.14.1 (21-Jun-2019)
    Added new reporting options:
    • --rows N - Output only the first N rows in "s", "ss" and "ee" reports.
    • -s {logreads | preads | pwrites | redo | wait_time} - Sort the "s", "ss", "ee" reports by this column.
    Posted Jun 21, 2019, 5:52 AM by Andrej Simon
  • Version 1.13.1 (12-Mar-2019)
    First version to support database releases 18c and 19c.
    Posted Mar 12, 2019, 1:44 PM by Andrej Simon
  • Beta Version 1.12beta2 (07-Aug-2018)
    Beta version with database 18c support.
    Posted Aug 7, 2018, 11:56 AM by Andrej Simon
  • Version 1.11 (29-Nov-2017)
    Minor bug fixes for the release 12.2.
    Posted Nov 29, 2017, 2:01 PM by Andrej Simon
Showing posts 1 - 5 of 26. View more »