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
About these ads

13 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

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

    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

    • 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 ?

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

5 Trackbacks

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

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

    […] http://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 […]

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 290 other followers