Query On SLEE_STATISTICS_DATA Cleanup (Doc ID 2030020.1)

Last updated on AUGUST 24, 2020

Applies to:

Goal

According to Oracle recommendations customer will need to clean the SLEE_STATISTICS_DATA table once a month and the SLEE_ALARM table every two months.

* Question 1

Customer wants to run statistics operations on last one year's data. What should be the cleanup frequency for SLEE_STATISTICS_DATA table ?

* Question 2

Customer currently keeps data in SLEE_STATISTICS_DATA for 6 months. Its size in production is about 778 MB. We intend to keep this data for one year. So roughly the size would be about 1.6 GB . Will statistics operations have any issue with this ?

* Question 3

If SLEE_STATISTICS_DATA is cleaned once a month, does it mean that statistics reports can be taken for up to one month's data only ?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.