AWR Report

Points to looks for in awr report

DB Time
Instance efficiency
Top 10 foreground events by wait time

Method to run awr report

Move to $ORACLE_HOME/rdbms/admin and run awrrpt.sql from sys

Enter report type
Enter value for num_days
Begin snap
End snap
report name

ASH report

Helps in getting session level details which may not been captured in AWR report

Points to look for in ASH report

Top user events
Top background events
Top event p1/p2/p3 values db/inst
Top service/module
Top sql command types db/inst
Top sql statement
Top sessions
Top blocking sessions
Top db objects
Top db files
Activity over time

Method to run awr report

Move to $ORACLE_HOME/rdbms/admin and run ashrpt.sql file

enter report type
begin time
duration
report name