Using Automatic Data Optimization

To implement your ILM strategy, you can use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database. The functionality includes the ability to create policies that specify different compression levels for each tier, and to control when the data movement takes place.

This section contains the following topics:

• Managing Policies for Automatic Data Optimization

• Creating a Table With an ILM ADO Policy

• Adding ILM ADO Policies

• Disabling and Deleting ILM ADO Policies

• Specifying Segment-Level Compression and Storage Tiering With ADO

• Specifying Row-Level Compression Tiering With ADO

• Managing ILM ADO Parameters

• Using PL/SQL Functions for Policy Management

• Using Views to Monitor Policies for ADO

To use Automatic Data Optimization, you must enable Heat Map at the system level. You enable this functionality with the HEAT_MAP initialization parameter. For information about setting the HEAT_MAP initialization parameter, refer to "Enabling and Disabling Heat Map".