DBA_ILMPARAMETERS can be queried to provide information on the Automatic Data Optimization parameters in the database and their values.
Note:
Automatic Data Optimization is not supported with a CDB.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| 
 
  | 
 
  | 
 Name of the Automatic Data Optimization environment parameter. The value is one of the constants defined in the   | 
|
| 
 
  | 
 
  | 
 Value of the parameter  | 
See Also:
Oracle Database PL/SQL Packages and Types Reference for more information about the API interface for implementing Automatic Data Optimization strategies
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_ILM_ADMIN package