This is a document I initially wrote, almost two years ago, for one of my clients to help developers interpreting AWR reports. I believe it is interesting to share it world wide
Diagnosing the past using AWR-hard parse headache
I have two other documents concerning two others situations where AWR report has been very helpful and which I hope to share with you when I will make them publishable.