Growth Control Methods
- Archiving and purging
- Database compression
Data Management Methods
- Database Partitioning
- Oracle Information Lifecycle Management (ILM)
A new Oracle whitepaper discussing these topics is now available:
This whitepaper discusses how these approaches can be used either individually or together to meet your requirements. Some examples scenarios:
- Adopt a 100% pure archive and purge strategy where any important data is initially archived and then finally purged when it is no longer needed. The archived tables could be placed in a read-only schema and the datafiles could be resized to reduce their physical space. In addition, database compression feature could be used in conjunction with or as an alternative to resizing the datafiles.
- Customers could adopt a combination of an archive/purge and ILM strategy, where inactive data is put onto cheaper storage, then after a period of time, this data is archived and eventually purged. Alternatively, customers could choose not to use ILM but instead use database partitioning.
- Customers could fully implement ILM and. and place less frequently accessed data, that would ordinarily be archived and purged, onto cheaper and less expensive storage devices.
- Customers could use a 3rd Party archiving product with Oracle’s ILM product.
Although there's a lot of conceptual and strategically-oriented material in this whitepaper, it also has concrete and practical information about:
- The E-Business Suite Purge Portal
- Archiving and purging programs and affected tables for the following products:
- Oracle General Ledger (GL)
- Oracle Payables/Oracle Purchasing (AP/PO)
- Oracle Receivables (AR)
- Oracle Cash Management (CE)
- Oracle Fixed Assets (FA)
- Oracle Cost Management (CST)
- Order Management (ONT)
- Oracle Application Object Library (FND) and Workflow (WF)
- How to use the Oracle ILM Assistant with an E-Business Suite environment
- Defining data classes
- Creating storage tiers for data classes
- Creating data migration policies
- Defining and enforcing compliance policies
- Considerations when creating an information lifecycle management framework for Apps data