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

  • 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
  • Version 1.10 (25-May-2017)
    Minor bug fixes.
    Posted May 25, 2017, 6:28 AM by Andrej Simon
  • Version 1.9 (13-Sep-2016)
    • Removed limit for -t report option. Added "baseline" specific name for -t option to show recommended statistics.
    • Added multitenancy support to -t option.
    • Removed limit for the number of filter options (-f). Many filters are allowed. It's possible to use "+" and "-" characters in the filter name to specify OR or NOT condition. The default condition is AND.
    • Added new -as (ASH sessions) report.
    • Improved multitenancy support.
    Posted Sep 13, 2016, 9:16 AM by Andrej Simon
  • Version 1.8 (15-aug-2016)
    • Added PDBs system parameters to parameter view ('g"/"z").
    • Added dNFS report (-o dnfs) based on V$DNFS_STATS view.
    • Added RMAN async IO report (-o rai) based on V$BACKUP_ASYNC_IO view.
    • Added RMAN sync IO report (-o rsi) based on V$BACKUP_SYNC_IO view.
    • Bug fixes for Multitenancy support.
    Posted Aug 15, 2016, 1:11 PM by Andrej Simon
Showing posts 1 - 5 of 23. View more ยป