Initial Configuration During Provisioning
Information Lifecycle Management (ILM) is delivered with some tables configured by default. As part of the Sales process, a sizing spreadsheet is filled out with customer to identify the Initial Partitioning for ILM, which is to plan for historical data (as part of Data Conversion activities) considered for loading into the cloud service application.
Based on the values provided, during the provision process, historical partitions are created to support the implementation, however once environments are provided to the customer, it is the customer's responsibility to make sure that Initial ILM Configuration is reviewed to ensure support for the project requirements, and that ILM batch controls are configured as part of monthly scheduler batch stream.
During provisioning, all historical partitions are created for all ILM enabled tables based on Hybrid Columnar Compression (HCC) type except for last month, current, future month and PMAX are created as Advance Compression type. For more information on Table compression types, refer to Oracle Advance Compression
Note: Despite the fact that ILM is available in all environments, Prod is the environment where ILM is applicable. Testing of ILM partitioning, and compression can ONLY be performed either in Prod or Prod equivalent sized environments.