1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Resolving Performance Degradation Over Time
  4. Using the AWR Compare Periods Reports
  5. Supplemental Information in the AWR Compare Periods Report

Supplemental Information in the AWR Compare Periods Report

The supplemental information is at the end of the AWR Compare Periods report, and provides additional information about initialization parameters and SQL statements. The init.ora Parameters section lists all the initialization parameter values for the first snapshot set. The Complete List of SQL Text section lists each statement by SQL ID and shows the text of the SQL statement.