I’ve had a recent request to write an update on working with AWR reports, so as promised, here it is! The Automatic Workload Repository The Automatic Workload Repository, (AWR) was one of the best enhancements to Oracle back in release 10g.  There was quite a goal put in front of the development group when they were asked to develop a product that: 1.  Provided significant performance recommendation and wait event data enhancements over its predecessor statspack. 2.  Was always on, meaning that the data would continually collect without manual intervention from the database administrator. 3.  Wouldn’t impact the current processing,…