Hello
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>