5.100 DBA_ILMPARAMETERS

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 supported in Oracle Database 12c Release 2 multitenant environments.

Column Datatype NULL Description

NAME

VARCHAR2(128)

Name of the Automatic Data Optimization environment parameter. The value is one of the constants defined in the DBMS_ILM_ADMIN package.

VALUE

NUMBER

Value of the parameter

See Also: