Generating Various Types of AWR Reports

•  awrrpt.sql
  Displays various statistics for a range of snapshots Ids.
  
  
• awrrpti.sql
  Displays statistics for a range of snapshot Ids on a specified database and instance.
  
  
• awrsqrpt.sql
  Displays statistics of a particular SQL statement for a range of snapshot Ids. Run this report to inspect or debug the performance of a particular SQL statement.
  
  
• awrsqrpi.sql
  Displays statistics of a particular SQL statement for a range of snapshot Ids on a specified SQL.
  
  
• awrddrpt.sql
  Compares detailed performance attributes and configuration settings between two selected time periods.
  
  
• awrddrpi.sql
  Compares detailed performance attributes and configuration settings between two selected time periods on a specific database and instance

Baselines

A baseline is a pair of snapshots that represents a specific period of usage. Once baselines are defined they can be used to compare current performance against similar periods in the past. You may wish to create baseline to represent a period of batch processing.

BEGIN
  DBMS_WORKLOAD_REPOSITORY.create_baseline (
    start_snap_id => 210, 
    end_snap_id   => 220,
    baseline_name => 'batch baseline');
END;
/

The pair of snapshots associated with a baseline are retained until the baseline is explicitly deleted.

BEGIN
  DBMS_WORKLOAD_REPOSITORY.drop_baseline (
    baseline_name => 'batch baseline',
    cascade       => FALSE); -- Deletes associated snapshots if TRUE.
END;
/

Baseline information can be queried from the DBA_HIST_BASELINE view.