ASH Queries
- Level 1 : Overview Queries
- ASH Report sql
- Activity sql output
- Average Activity sql output
- Average Activity Pivot sql output
- Foreg/backg sql output
- SQL/no SQL sql output
- ASL 1 minute buckets sql output
- Level 2 : Aggregate
- Top SQL topsql.sql output
- Top Session topsesn.sql output
- Top Package/Procedure ashpl2.sql output
- Level 3 : Wait Specific Queries and Drill Downs
- Buffer Busy Waits bbw.sql output
- TX locks tx.sql output
- IO io.sql output
- Row Cache rc.sql output
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