ASHMON v2

Presentation What is ASH

Install

Download: ashmon.zip
         Windows Only (portable to UNIX with TCL/TK executable for UNIX)
Unzip ashmon.zip
Run ashmon.bat
         with ashmon\bin\ as the starting directory
Login as "system"
Supports 10g or 11
         can run on earlier versions of Oracle with S-ASH repository S-ASH
         need to create some veiws on SASH as well as wait groups

 

Based on ASH
System Load
measured in AAS - Average Active Sessions
broken down into CPU and wait group states
window slider (mouse click drag, release)
Top SQL in window
( Top Session in window - not implemented yet)
Zoom in on Load (right click start, right click finish, clear with double click)
SQL Text for selected SQL
SQL execution time line (click twice on SQL id)

• 10.1 ASHMON gets errors because v$active_session_history is missing wait_class. workaround
• if copying ashmon.bat to your desktop or elsewhere, use a "shortcut" instead of moving the file. The file needs to be located in ashmon/bin
• only connect to Oracle 10g or 11 unless you have set up the S-ASH repository
• only connect as system or someone who has select on v$ tables unless you have set up the S-ASH repository. script to grant select on v$ views or grant "SELECT_CATALOG_ROLE" to the user.
• All connect errors return "invalid username/password" in Oratcl, thus to debug connection problems you need to test with sqlplus. If sqlplus connects, then the monitor will connect with the same connection string ie username, password and tnsnames.ora entry
• ashmon will use the tnsnames.ora located in ORACLE_HOME found in the PATH variable on windows. IE if sqlplus executes C:\oracle\bin\sqlplus then ashmon will use C:\oracle\network\admin\tnsnames.ora
• ashmon comes with a default oracle client libraries and will use these if it does not find Oracle already installed on the PC, and will use ashmon/oracle/network/admin/tnsnames.ora for tns alias lookups