ASH Viewer

If you like Top Activity page of the Oracle EM console, but don’t have it up and running or want to simulate the same in 8i/9i, then here is an open-source standalone program to do that: ASH Viewer.

Here are several screen shots of it:

Login screen

Main window

SQL Text (automatically reformatted)

SQL Plan (from V$SQL_PLAN, I guess). There's a button to customize displayed columns.


ASH Report

ASH Details - breakdown by wait class

ASH - history view. ASH data is stored in a local DB.

ASH - history view. ASH data is stored in a local DB.

Some notes:

  • is in the Windows format, so you have to do “dos2unix” otherwise you’ll receive “bash: ./ /bin/sh^M: bad interpreter: No such file or directory” error
  • for unknown reason it is recommended to connect as SYSTEM, which is definitely bad idea
  • See readme.txt for more details and known issues


  1. JC Dauchy
    Posted May 5, 2010 at 17:54 | Permalink | Reply

    On a 2 nodes RAC, should I start 2 Ash viewers on both nodes ? I mean the Active sessions informations are spread on both nodes, looking quickly at your query, it seems that you query v$active_session_history

    By the way, awesome tools !!

    • Posted May 5, 2010 at 20:05 | Permalink | Reply

      Hello Jean-Christophe,

      Yes, RAC installation would require one ASH viewer per instance since currently the tool can access V$ACTIVE_SESSION_HISTORY only. And, BTW, I’m not the author of this tool 🙂

  2. JC Dauchy
    Posted May 6, 2010 at 17:58 | Permalink | Reply

    I tried to modified the URL in the INI file of each instance to make sure that it is connected to the right instance, but i guess the string was too long.. I’ll contact the author then to see if he can change the length of the string.


  3. Posted March 6, 2011 at 21:18 | Permalink | Reply

    nice article about ASH viewer …

  4. Matt
    Posted April 6, 2011 at 23:01 | Permalink | Reply

    Does anyone know how to set up the history? I can’t see any config options in the app or a help file.

    • Posted April 7, 2011 at 07:29 | Permalink | Reply

      Hi Matt,

      AFAIR it saves the history in the current directory of the program in a separate folder for each connection. Is it enough for you or you want to see something else?

  5. Mayank
    Posted March 31, 2014 at 15:02 | Permalink | Reply

    I am running ash-viewer and after providing connection details in GUI, it fails with below error
    I am on , so i have downloaded equavalent jdbc driver ojdbc6.jar and put in lib directory

    tgrprd@illin621:tgrprd/mak/STATS/ashv-3.4-bin> /usr/java/jdk1.6.0_24/bin/java -Xmx128m -jar ASHV.jar
    SQL Exception occured while connection pool initialize: Canât find class for driver: oracle.jdbc.pool.OracleDataSource

    SQL Exception occured while connection pool initialize: Canât find class for driver: oracle.jdbc.pool.OracleDataSource

    please suggest

    • Posted March 31, 2014 at 20:12 | Permalink | Reply


      try using Java 1.5 and ojdbc5.jar. As far as I remember, 1.6 driver did not work. I may be wrong on this though and the could be somewhere else.

  6. pumu
    Posted May 6, 2014 at 19:16 | Permalink | Reply

    Is there any ay to use Ash Viwer with Oracle 12c Standard Edition ?

    • Posted May 6, 2014 at 20:02 | Permalink | Reply


      I haven’t tried it myself. It should work, I think, as it works OK with 11g.

      • pumu
        Posted May 6, 2014 at 23:41 | Permalink | Reply

        I tried it, but had problems with the jdbc, what kind of jdbc driver I need and does it work with JRE 1.7 ?

      • pumu
        Posted May 13, 2014 at 16:46 | Permalink | Reply

        I can get a connection to 11g database, but not 12c: SQL Exception occured while connection pool initialize: ORA-28040: No matching authentication protocol. Any Suggestion ?

        • Alexey
          Posted June 24, 2014 at 09:30 | Permalink | Reply

          Setting SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 should help.

          • Den
            Posted April 28, 2017 at 21:38 | Permalink | Reply

            no, it doesn’t. I set it everywhere – client,server db home,server asm home – no effect

            • Nadezhda
              Posted September 28, 2017 at 17:49 | Permalink | Reply

              Try to use ojdbc6.jar instead of ojdbc14.jar

  7. Peter King
    Posted October 8, 2015 at 17:57 | Permalink | Reply

    THe #sessions onda te vertical axis get sporadics wrong results.
    Working with 11gR2 XE
    Any ideas ?


6 Trackbacks

  1. […] 14-ASH viewer tool Timus Akhmadeev-ASH Viewer […]

  2. By Free ASH « Oracle Scratchpad on March 6, 2011 at 21:06

    […] […]

  3. By » Best Oracle Peformance Tools? on March 26, 2011 at 07:52

    […] Ashviewer […]

  4. By | xfang on December 28, 2012 at 18:29

    […] ASH from the databsase but can use S-ASH. For tools that both collect and read ASH check out  ASHVIEWER and LAB128. LAB128 is pay for but does more than just collect ASH and ASHViewer is free but only […]

  5. By Kyle Hailey » Best Oracle Performance Tools on September 16, 2013 at 20:46

    […] Ashviewer […]

  6. […] site: […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: