Reporting Tool AREPTO.

This is a main page of AREPTO, the free interactive tool for getting performance details about SQL cursors. The tool helps as well to search for specific details in ASH.

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

The tool executes only SELECT statements, so that you can easily test and use 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. If you are comfortable with the Oracle dynamic views, then you could of course get all information just using SQL*Plus. But using AREPTO is sometimes easier.
  3. You are already using a UNIX terminal for your work. So If you want to check some information, it's faster to use AREPTO instead of starting a GUI or a browser.
  4. AREPTO provides some reports (text and HTML), so that you can quick collect the information and analyze it later.
  5. If you already use AMON, you would like to find in this tool the missing details about SQL cursors and ASH.

This tool is developed by Andrej Simon, Oracle ACS Germany in my free time. If you have any questions or comments, please contact me directly(

Version history

  • Version 1.9 (19-Sep-2016) Minor bug fixes.
    Posted Sep 19, 2016, 12:44 PM by Andrej Simon
  • Version 1.8 (03-Jan-2016) Added ADDM reports for last 2 days.Added AUTO advisory reports for SQL profiles and SPMs for last 7 days.Added last DBMS_STATS reports.Added SPM XPLAN output.Added ...
    Posted Sep 19, 2016, 12:39 PM by Andrej Simon
  • Version 1.7 (14-Nov-2015) Added more columns from DBA_TAB_COL_STATISTICS to table report.Added histograms to table report.Added table statistics and histograms for partitions and subpartitions to table report.Added adaptive ...
    Posted Sep 19, 2016, 12:39 PM by Andrej Simon
  • Version 1.6 (01-Nov-2015) Improved support for database release a new file stmt.sql with original SQL statement. 
    Posted Nov 8, 2015, 6:37 AM by Andrej Simon
Showing posts 1 - 4 of 4. View more »

Freeware disclaimer: The author, Andrej Simon, of this freeware accepts no responsibility for damages resulting from the use of this product and makes no warranty or representation, either express or implied, including but not limited to, any implied warranty of merchantability or fitness for a particular purpose. This software is provided "AS IS", and you, its user, assume all risks when using it.