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
Steps for reading AWR Report Follow screenshots in order
No comments:
Post a Comment