Friday 28 February 2014

Reading AWR Report


Reading Automatic Workload Report

A well formated AWR report can be got from ITG logon if your office has configured this. Or it can be got from SQL developer. Though the sql developer one is not formated it should be readable.

 

 



The Active Session History (ASH) reports enable you to analyze transient performance problems with the database that are short-lived and do not appear in the ADDM analysis.


The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time, and resolve performance degradation that may happen from one time period to another.

Few very good Articles on active session history , V$session in oracle. The links are in order in which they are supposed to be read





http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13dba-1871177.html


Steps for reading AWR Report Follow screenshots in order 












No comments:

Post a Comment