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


DBA & Infrasturcture

Date and time

Wednesday, 18. October 2017., 09:50


Hall B



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

Lecture details

Type: Lecture
Level of difficulty: Detailed
Experience Level: No experience
Desirable listeners function: DBA , Developers

About speaker

Best Sponsor

Better Sponsor

Media Sponsor

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at

Follow us on Facebook

Follow us on Twitter

Keep yourself up to date with all updates!