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:
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
16 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?
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
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.
Is there any ay to use Ash Viwer with Oracle 12c Standard Edition ?
Hi,
I haven’t tried it myself. It should work, I think, as it works OK with 11g.
I tried it, but had problems with the jdbc, what kind of jdbc driver I need and does it work with JRE 1.7 ?
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 ?
Setting SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 should help.
no, it doesn’t. I set it everywhere – client,server db home,server asm home – no effect
Try to use ojdbc6.jar instead of ojdbc14.jar
THe #sessions onda te vertical axis get sporadics wrong results.
Working with 11gR2 XE
Any ideas ?
Regards
PGutierrez
6 Trackbacks
[…] 14-ASH viewer tool Timus Akhmadeev-ASH Viewer […]
[…] https://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 […]
[…] Ashviewer […]
[…] site: https://timurakhmadeev.wordpress.com/2010/02/18/ash-viewer/ […]