DBA & Infrasturcture
Wednesday, 18. October 2017., 09:50
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
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.