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:
- 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.
- 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.
- 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).