Can anyone please share the steps to purge historical data before 365 days from Automic/UC4 (v9 and 10) database as the size of the database is increasing rapidly.
I assume you have access to the utilities. This topic should help you out: DB Maintenance with Automic utilities
Thanks for replying back and sharing the link
I already gone through this link and setup maintenance jobs in UC4. Tried run it, everything ran smoothly. But could not find any decrease in size of the database or oracle datafile. Still the size remains same. Today morning again ran shrink on tablespace gained 1GB free space.
My UC4 database size is around 77GB
Not sure if anything I missed out to clear properly.
Well, I am no DBA, but from my experience 77 GB for a system that has a years worth of reports and statistics is not that much.
Have you checked the reports of the utilities ? There you can find what exactly is being reorganised, and how many entries are removed. That would give you an estimation how much data you get rid of with every reorg.
Thanks for the useful steps. Let me give it a try.
In Oracle, deleting data does not automatically reclaim disk space. The database will retain its storage until you do something administrative to the tablespace. The expectation of this behavior is that if you needed the storage at one time, you will likely need it again and it would therefore be more efficient to simply keep the allocation.
To reclaim the space, you have a few choices. The following article from Oracle-DBAs has a pretty comprehensive look at this situation: https://oracle-base.com/articles/misc/reclaiming-unused-space
Thanks for sharing the link.
I will try some work around on these options mentioned in the link.
Retrieving data ...