Organizations can mitigate the impact of data growth by running batch reports during downtimes, creating additional partitions, purchasing faster hardware or utilizing the purge functionality within the application stack. None of these techniques fully address the reality of application growth coupled with the need for long term data retention. It’s important to maintain performance of Oracle Applications while ensuring compliance.
With E-Business Suite Archiving organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.
This helps in maintaining integrity and reduces the strain on database servers. When a quarterly or yearly trend analysis is performed, it allows for convenient data purging also. Automation of archiving and purging is available as data archiving solutions. They can be used by multiple projects at the same time and data retrieval is very convenient.