The reports that we get from the AWR tables include information such as a comprehensive list of the top SQL and query plans by various criteria, a list of all of the tables in our application and the query plans that reference each of the tables, and a list of all of the indexes in our application and the query plans that reference each of the indexes.