AWR Report – Automatic Workload Repository It will generated a performance related server reports. 10 g Feature. Prior to 10 g ‘Stats pack report’ has used. AWR Stats Pack Text (or) HTML Text Any timeframe with ASH Any timeframe Server level all resources reports Parameters: Statistics_level = Basic/Typical/All – Based on the parameter report will be generated. The information will gathered from following five categories. Base Statistics Matrix Statistics SQL Statistics Active Sessions Advisory Results Physical Reads, CPU Base+ Memory, Object memory utilization, Every past 10 minutes once Logical reads from the query All active session with RAM usage SQL,SQL Tuning, Memory, Segment & Undo Advisory…