Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AWR reports

unknown-1052419Mar 11 2014 — edited Mar 12 2014

Hi all,

11.2.0.1

I really still can not understand what to look into AWR

Give two(2) AWRs, one is baseline and one has performance issues.

What top items do I need to compare?

Our batch operators noted that their batch programs took more than 1 hr to complete today than yesterdays 40min.

Below are the two(2) awr for comparison.

https://app.box.com/s/6fqp0vcaiizx3wj9zmou

https://app.box.com/s/k4yg2y8tsvn8y21nk0qj

Can you tell which one is slow and which one is faster?

Thanks all,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2014

Added on Mar 11 2014

#general-database-discussions

25 comments

342 views