Query On SLEE_STATISTICS_DATA Cleanup
Last updated on JULY 27, 2017
Applies to:Oracle Communications Services Gatekeeper - Version 5.1.0 and later
Information in this document applies to any platform.
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 ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms