AWR AND ADDM ANALYSIS
AWR REPORT ANALYSING BY ANAND GUPTA 1. Introduction 1.1. Purpose of Document AWR (Automatic Workload Repository) Reports are very handy during performance tuning of the database. These reports provide clear picture of database side activities. Various useful data is nicely documented in different sections in readable format. It becomes necessity to understand these reports for teams involved in activities like database tuning,performance/load testing or analyzing any performance issue. Purpose of the document is to enable the reader to understand basic AWR terminology and to use these details for understanding the database performance issues. 1.2. Scope This document describes how to utilize AWR reports to tune, · ...