ASH and AWR Scripts for Checking Wait Events and Top Consuming SQL's Shadab Mohammad 8 years ago http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/ Share this: ASH Script for Finding out Top Wait Events in OracleJune 18, 2015In "11gR2"Active Session History 11gMarch 29, 2012In "Database"Scripts to Check Library Cache Lock ContentionOctober 20, 2015In "11g"