ORACLE DBA - AWR Report

Automatic workload repository (AWR)is a collection of persistent system performance statistics owned by SYS.

AWR generates snapshots of key performance data, such as system and session  statistics , segment-usage statistics, time-model statistics, high-load   Statistics   resides in SYSAUX tablespace. By default snapshot are generated once every 60min and aintain   for 7 days by default.

We can generate AWR reports by running SQL scripts

The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range Of snapshot Ids.

The awrrpti.sql SQL script generates an HTML or text report that displays statistics for a range  of snapshot Ids  on a specified database and instance

• At the SQL prompt, enter:

      @$ORACLE_HOME/rdbms/admin/awrrpt.sql

      @$ORACLE_HOME/rdbms/admin/awrrpti.sql