From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Understanding the AWR report

Understanding the AWR report - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Understanding the AWR report

“

- [Instructor] Logical tuning is the next step of optimization, but how do you know what needs to be optimized and what tools are provided by Oracle? The automatic workload repository, also known as the AWR, is an always-on collection of metrics data that is retained, aggregated, and a series of reports provided by Oracle. The metric data in the repository is also stored in a robust set of tables to be queried directly. The descendant of previous iterations of optimization reporting tools, the last being Statspack. There is required licensing to use the AWR through the Diagnostic and Tuning Management Pack, and is licensed at the database level. If the management pack isn't licensed, Statspack can still be installed and configured manually to use, even today. The AWR is configured by default to retain eight days of data, information collected in a series of snapshots by the MMON process on an hourly basis. As part of the AWR, the active session history, also known as ASH, is also…

Contents