Skip to Main Content

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!

Can ADDM & AWR generate report not covered by retention period?

jlmedes_mbJun 26 2016 — edited Jun 28 2016

I need to generate ADDM & AWR report for June 9 5:50pm to 6:40pm. my snapshot available is only up to June 19, 2016 11am

pastedImage_0.png

Checked from google but all is see are examples to run the awwrpt.sql but does not show to give date not covered by retention.

my dba_history_snapshot min id is just 11 snapshots from june 19 - 11 hours.

pastedImage_1.png

Please advise if you know work around. Thanks in advance.

This post has been answered by asifkabirdba on Jun 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2016
Added on Jun 26 2016
14 comments
6,887 views