Oracle Scratchpad

March 6, 2011

Free ASH

Filed under: Troubleshooting — Jonathan Lewis @ 6:04 pm GMT Mar 6,2011

If you’re running a version of Oracle older than 10g (where v$active_session_history appeared), or if you’re not using Enterprise Edition, or if you just don’t want to pay for the Diagnostic Pack licence, here are some links relating a free Java program that emulates the “Top Sessions” output of the Enterprise Manager screen:

Important Note:

If you want to query v$active_session_history (or any of the AWR objects) then you need to purchase the licence for the Diagnostic Pack). If you aren’t licensed you should only use the program in emulation mode.


  1. Hi Jonathan,

    There is one more project which is providing simulating free ASH –
    It is based on Kyle Hailey code and now I have added some new features. Hope I will finish new version soon
    with support for Oracle RAC and multiple databases in one ASH repository.
    I have contacted author of ASHV some time ago as I was looking for graphic fronted for my project and now I’m checking possibility of use
    ASHV for viewing SASH schema as well.


    Comment by Marcin Przepiorowski — March 7, 2011 @ 9:19 am GMT Mar 7,2011 | Reply

  2. Hi Temur Ahmadeev

    Great piece of work . Would have been more beautiful if the application can view historical data as in Oracle EM.


    Comment by Ahmed — April 27, 2011 @ 10:50 am BST Apr 27,2011 | Reply

  3. Hi
    Actually the app DO HAVE historical data , stored in an embedded java db ( sleepycat DB ) and you can browse thru it

    Comment by patrick boulay — August 9, 2011 @ 5:02 am BST Aug 9,2011 | Reply

  4. I use ASHV fairly often. The interface for browsing the data is quick and intuitive and it is nice because you have more control over ‘zoom extents’ than OEM when you view the data. Depending on the screen you are using in OEM you are constrained to 5 minute or 30 minute intervals. ASHV allows you to drill down to any two points. Very helpful for zeroing in on issues that don’t fit nicely in a 5 minute or 30 minute window.

    I have been trying to get in touch with the author to see if he is interested in updating or opening up the project to new development. I found some bugs that prevent me from connecting to some 11g databases. It is GPL so I could fork it but I will give the original author another shout.

    The internal embedded Java DB seems to just capture what you are currently browsing, and you can view it later. I think Ahmed is probably thinking about the body of ASH data stored within the database, not just what is captured from the DB while ASHV is running.

    Comment by dmann99 — January 15, 2012 @ 9:38 am GMT Jan 15,2012 | Reply

  5. […] technology can only be licensed with the Enterprise Edition of Oracle. (Which is why there are some ASH emulators on the […]

    Pingback by Trouble-shooting | Oracle Scratchpad — December 4, 2015 @ 7:22 am GMT Dec 4,2015 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply to Ahmed Cancel reply

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

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

Google photo

You are commenting using your Google 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by