Oracle Scratchpad

March 6, 2011

Free ASH

Filed under: Troubleshooting — Jonathan Lewis @ 6:04 pm BST 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:

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

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.

4 Comments »

  1. Hi Jonathan,

    There is one more project which is providing simulating free ASH – http://sourceforge.net/projects/orasash/
    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.

    regards,
    Marcin

    Comment by Marcin Przepiorowski — March 7, 2011 @ 9:19 am BST 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.

    Thanks.

    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 BST Jan 15,2012 | Reply


RSS feed for comments on this post. TrackBack URI

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

Theme: Rubric. Get a free blog at WordPress.com

Follow

Get every new post delivered to your Inbox.

Join 4,257 other followers