ASH and AWR Scripts for Checking Wait Events and Top Consuming SQL's Shadab Mohammad 9 years ago http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/ Share this: ASH Script for Finding out Top Wait Events in OracleDateJune 18, 2015In relation to11gR2Active Session History 11gDateMarch 29, 2012In relation toDatabaseScripts to Check Library Cache Lock ContentionDateOctober 20, 2015In relation to11g