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!

How to pull history SQL queries before 18 day's

914700Feb 1 2012 — edited Feb 2 2012

Hi,

I tried to pull the Awr report for the SQL history queries. Unfortunately it is saved only for 7 days. There is any way I can retrieve the history SQL from dictionary tables. I have access to all the DBA views. Please let me know if you need any further information.

Thanks,
Swagath

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2012

Added on Feb 1 2012

#general-database-discussions

4 comments

186 views