Oracle DBA’s can spend massive amounts of time trying to pinpoint the cause of DB performance issues. The more complicated the infrastructure stack, the more difficult it is to figure out the root cause of issues. Luckily, Oracle has in-built mechanisms to help DBA’s quickly identify performance bottlenecks – the Automated Workload Repository (AWR).
This short guide provides a crash course into how to quickly analyze AWR reports to identify performance issues, as well as possible infrastructure solutions that can help ensure that those problems are eliminated for good.