Skip to content

ASH Viewer provides a graphical view of active session history data within the Oracle instance (versions supported: 8i/9i/10g/11g)

License

Notifications You must be signed in to change notification settings

mdementyev/ASH-Viewer

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

				ASH Viewer
				
  What is it?
  -----------
  ASH Viewer provides graphical view of active session history data within the Oracle instance. 

  Active Session History (ASH) is a view in Oracle that maps a circular buffer in the SGA.
  The name of the view is V$ACTIVE_SESSION_HISTORY. This view is populated every second
  and will only contain data for 'active' sessions, which are defined as sessions
  waiting on a non-idle event or on a CPU.

  ASH Viewer provides graphical Top Activity, similar Top Activity analysis and Drilldown
  of Oracle Enterprise Manager performance page. ASH Viewer store ASH data locally using
  embedded database Oracle Berkeley DB Java Edition. The default capture rate is one snapshot
  every 30 seconds. ASH Viewer support 10g, 11g version of Oracle DB. Use SYSTEM database user
  to connect to Oracle DB. Please note that v$active_session_history is a part of the Oracle Diagnostic Pack
  and requires a purchase of the ODP license.
  
  For Oracle 9i(8i) DB, ASH Viewer emulate ASH, storing active session data on local storage.
  The default capture rate is one snapshot every 1 second. For Oracle 9i(8i) DB,
  user SYSTEM must have access rights to the views sys.x_$ksuse, sys.x_$ksusecst
  
  	create view x_$ksuse as select * from x$ksuse;
	create view x_$ksusecst as select * from x$ksusecst;
	
	grant select on sys.x_$ksuse to system;
	grant select on sys.x_$ksusecst to system;

  System Requirements
  -------------------
  JDK:
    1.5u11 or above.
  Memory:
    Minimum 128 Mb. Recommended 192 Mb.
  Disk:
    It depends on Oracle workload.
  Operating System:
    No minimum requirement.

  Running ASH Viewer
  ----------------
  1) Unpack the archive, eg:
      unzip ashv-<<version>>-bin.zip

  2) A directory called "ashv-<<version>>-bin" will be created.

  3) Download JDBC driver ojdbc6.jar from http://otn.oracle.com and put it to ashv-<<version>>-bin/lib directory.

  4) Make sure JAVA_HOME is set to the location of your JDK, 
  	  see run.cmd/run.sh (on Windows/Unix platform).

  5) Create monitor user in Oracle DB and grant select and execute priviliges using user_privs.sql file.

  6) Run run.cmd/run.sh (on Window/Unix).

   Known issues
  --------------
   Problem: When running ASH Viewer on JRE6, dragging window slider on Top Activity is too slow
   Workaround: use JDK5+ or JRE5 to run ASH Viewer
   
   Problem: On Oracle 9i, select from v$sql_plan, cause extreme library cache latch contention 
   Workaround: collect statistics on fixed table x$kqlfxpl to resolve this issue:
   				SQL> exec dbms_stats.gather_table_stats('SYS','X$KQLFXPL');
   
   Licensing
  ---------
   Please see the file called LICENSE

   ASH Viewer URL
  ----------
   http://ashv.sourceforge.net
   https://github.com/akardapolov/ASH-Viewer
   

About

ASH Viewer provides a graphical view of active session history data within the Oracle instance (versions supported: 8i/9i/10g/11g)

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Java 100.0%