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
6 Comments
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
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
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
nice article about ASH viewer …
Does anyone know how to set up the history? I can’t see any config options in the app or a help file.
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?
4 Trackbacks
[...] 14-ASH viewer tool Timus Akhmadeev-ASH Viewer [...]
[...] http://timurakhmadeev.wordpress.com/2010/02/18/ash-viewer/ http://sourceforge.net/projects/ashv/ [...]
[...] Ashviewer [...]
[...] 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 [...]