When we want to generate the #AWR report, we usually run the awrrpt.sql script. We don’t need to be on the #database #server for that – we just need the awrrpt script and the scripts it calls – so any database server installation will do. Once we connect to the database and run the script, it will automatically run the relevant queries and scripts and generate the report.
Automatic Workload Repository report or AWR report collects, processes, and maintains performance statistics for problem detection and selftuning purposes. This gathered #data is stored both in memory and in the #database, and is displayed in both #reports and #views.

00:00 Introduction
01:25 Snapshots
03:46 DBMS_Workload_Repository
06:39 Generate AWR report
16:40 AWR report example
18:35 Work load repository
20:55 Report summary
21:43 Load Profile
30:41 Instance Efficiency Percentages
33:12 Shared Pool Statistics
35:12 Top 10 Foreground Events by Total Wait Time
42:21 Wait classes by Total Wait Time
50:53 Log Buffer Space
55:07 SQL Statistics

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis