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 and ASH reports

$phinx19Mar 28 2019 — edited Mar 29 2019

Hi All,

OS:RHEL

DB:11204

Wat is the main difference between AWR and ASH report.

Does Awr gives the full list of SQL or ASD does for the specified time frame.

When to use AWR and when to use ASH ?

I have tried to google it but unable to get specific answers.

Kindly advise

Thanks!

Added on Mar 28 2019

#general-database-discussions

6 comments

4,660 views