Mining the AWR v1: Alternative Methods for Identification of the Top SQLs

We can use AWR reports to quickly identify the SQL_IDs of the top statements in the database. But what if the AWR report reveals no \"low-hanging fruit,\" and the resource usage is evenly distributed among multiple statements? Where do we start? Is there a better way to identify the starting point for the tuning of a resource-bound system? This presentation will explain when the AWR reports are misleading and how we can take a look at the data stored in AWR from a different angle to determine the top consumers. Discussion will include a practical demonstration using scripts for AWR mining that attendees can apply to their own challenging database performance tuning problems