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.

SQL Plan (DBMS_XPLAN.DISPLAY_CURSOR)

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:

  • run.sh is in the Windows format, so you have to do “dos2unix run.sh” otherwise you’ll receive “bash: ./run.sh: /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
This entry was written by Timur Akhmadeev, posted on February 18, 2010 at 22:35, filed under Oracle, Performance and tagged . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

16 Comments

  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

    Thanks.
    By the way, awesome tools !!
    Jean-Christophe

    • Timur Akhmadeev
      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.

    Thanks

  3. Okcan Yasin
    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.

    • Timur Akhmadeev
      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

    Hi
    I am running ash-viewer and after providing connection details in GUI, it fails with below error
    I am on 11.2.0.2 , 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

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

      Hi

      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 ?

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

      Hi,

      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 ?

    Regards
    PGutierrez

6 Trackbacks

  1. By Blogroll Report 12/02/2009 – 19/02/2010 « Coskan’s Approach to Oracle on March 18, 2010 at 19:44

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

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

    […] https://timurakhmadeev.wordpress.com/2010/02/18/ash-viewer/ http://sourceforge.net/projects/ashv/ […]

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

    […] Ashviewer […]

  4. By http://dboptimizer.com/tools-2/ | 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. By 9 Ferramentas de Tuning grátis que você deve conhecer | DBTimeWizard on April 13, 2016 at 05:34

    […] site: https://timurakhmadeev.wordpress.com/2010/02/18/ash-viewer/ […]

Leave a comment