Oracle 视图 DBA_ILMOBJECTS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ILMOBJECTS是一个数据字典视图，显示当前用户或拥有更高级别权限的用户可以访问的所有ILM (Information Lifecycle Management) 对象。它提供对ILM对象及其属性的清晰概述。
该视图提供了以下列：
1.OBJECT_NAME：这是 ILM 对象的名称。
2.OBJECT_TYPE：这是 ILM 对象的类型，比如表，主键，索引等。
3.OWNER：这是 ILM 对象的所有者。
4.ILM_POLICY_NAME：ILM 针对该 ILM 对象的策略的名称。
借助该视图，可以查询被ILM策略管理的对象，比如表，索引，主键，外键等等，还可以查看这些对象的ILM政策的名称及查看它们的所有者。
官方英文解释
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 Oracle Database 12c Release 2 multitenant environments.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Policy name is auto-generated |
|
|
|
|
Owner of the object associated with the Automatic Data Optimization policy |
|
|
|
|
Name of the object associated with the Automatic Data Optimization policy |
|
|
|
Name of the subobject associated with the Automatic Data Optimization policy |
|
|
|
|
Object type. Valid values include:
Direct policies on Index, Index Partition, LOB, and LOB Partition are not supported in Oracle Database 12c. |
|
|
|
|
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 ( |
|
|
|
|
The tablespace name, if the policy is inherited from a tablespace |
|
|
|
|
Indicates if the Automatic Data Optimization policy is enabled for the object ( |
|
|
|
|
Possible values:
|
See Also:
“USER_ILMOBJECTS”
