Table of Contents
Oracle Database - AWR (Advanced Workload Repository)
About
Oracle AWR (Advanced Workload Repository) and ADDM (Automated Database Diagnostic Monitor) which are available since Oracle 10g are useful features for performance tuning and troubleshooting.
Articles Related
AWR Report
You can either use OEMDDC, which is the Enterprise Database Control to view the AWR snapshots, or can generate the AWR reports in text or HTML format.
By default for every database, Oracle automatically generates snapshots of the performance data once every hour and stores the statistics in the workload repository.
You can manually capture a snapshot if you want.
% sqlplus / AS sysdba SQL> exec dbms_workload_repository.create_snapshot;
You can run awrrpti.sql script to generate the report.
%sqlplus / AS sysdba SQL> @$ORACLE_HOME/rdbms/admin/awrrpti.sql
