- Version 2 - find v2 on the ashmasters.com blog. V2 works on standard edition Oracle and installs on Windows (v1 below only installs on UNIX)
- A Sampling We Will Go (pdf) - explains the power of using ASH
- S-ASH (v1)
- Download
- Instructions - how to install
- Analysis - sql data mining scripts
- Overhead - resource usage
- Administration - maintenance & problems
- If you use or appreciate the ASH simulator, please drop me a line at
kyle_hailey@hotmail.com
and let me know your experiences!
Oracle's ASH
- ash 10.1
- ash 10.2
- ash 11.0
- comparison html
- ASH view definition 10.2
- v$session/x$ksuse 9.2
- v$session/x$ksuse 10.2
ASH Queries
- ASH Report sql
- Activity sql output
- Foreg/backg sql output
- SQL/no SQL sql output
- ASL 1 minute buckets sql output
- ASH script repository