purge of AWR historical tables

At one project (Oracle 12.1) two of the AWR historical tables are occupying 1,8 TB.

· WRIS_OPSTAT_HISTHEAD_HISTORY : 81GB · WRI$_OPSTAT_HISTGRM_HISTORY : 1,012TB with almost 16 billion of rows

The last savtime from WRI$_OPSTAT_HISTGRM_HISTORY is from November 2018

Based upon the first suggestion of Oracle support the team has started by running the purge stats procedure which they have canceled after 3 hours.

Now the Oracle support is suggesting the following

· Drop indexes for those two tables

· Drop partitions older than 31 days

· Recreate indexes

Have you already been in such situations? If so, what strategy have you adopted to reduce the size of those two tables as quickly as possible?

Thanks

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -


<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin


Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri


<https://twitter.com/MohamedHouri>



--
http://www.freelists.org/webpage/oracle-l