1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_ILMOBJECTS

5.98 DBA_ILMOBJECTS

DBA_ILMOBJECTS displays all the Automatic Data Optimization policies and objects in the database.

Many objects inherit policies via their parent objects or because they were created in a particular tablespace. This view provides a mapping between the policies and objects and indicates whether a policy is inherited by an object or is directly specified on it.

Related View

USER_ILMOBJECTS displays all the Automatic Data Optimization policies and objects for a user.

Note:

Automatic Data Optimization is supported in multitenant environments starting with Oracle Database 12c Release 2 (12.2.0.1).

Column Datatype NULL Description

POLICY_NAME

VARCHAR2(128)

NOT NULL

Policy name is auto-generated

OBJECT_OWNER

VARCHAR2(128)

NOT NULL

Owner of the object associated with the Automatic Data Optimization policy

OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the object associated with the Automatic Data Optimization policy

SUBOBJECT_NAME

VARCHAR2(128)

Name of the subobject associated with the Automatic Data Optimization policy

OBJECT_TYPE

VARCHAR2(18)

Object type. Valid values include:

  • INDEX

  • INDEX PARTITION

  • LOB

  • LOB PARTITION

  • TABLE

  • TABLE PARTITION

  • TABLE SUBPARTITION

Direct policies on Index, Index Partition, LOB, and LOB Partition are not supported in Oracle Database 12c.

INHERITED_FROM

VARCHAR2(20)

Indicates if the policy is inherited by the object or subobject, or directly specified on the object or subobject. If the policy is inherited, the level from which the policy is inherited (TABLE, TABLE PARTITION, TABLESPACE) is identified.

TBS_INHERITED_FROM

VARCHAR2(30)

The tablespace name, if the policy is inherited from a tablespace

ENABLED

VARCHAR2(7)

Indicates if the Automatic Data Optimization policy is enabled for the object (YES or NO)

DELETED

VARCHAR2(7)

Possible values:

  • YES - Indicates that the policy is deleted for any objects that may be added in the future, but is active for those objects that are currently associated with that policy

  • NO - Indicates that the policy is active

See Also:

"USER_ILMOBJECTS"