Oracle 视图 DBA_ILMEVALUATIONDETAILS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ILMEVALUATIONDETAILS提供了基于传统技术和机器学习（Machine Learning）的估计参数的详细信息的可读形式。这对于管理和监督一个估计过程而言是有用的，因其会告诉你哪些参数代表什么，以及它们的转换方式，这有助于使用者或数据库管理员检查和调节这些估计参数和转换方式以满足他们的需求。
该视图包括了所有以及参数估计，以及它们的当前及改变后的状态。此外，它也可以为某些工作分配参数以提高估计精度以及提供一些有用的信息，如估算时间，以及相关任务之间的联系。
这个视图可以通过一个查询来获取所有的参数部分：
SELECT * FROM DBA_ILMEVALUATIONDETAILS;
官方英文解释
DBA_ILMEVALUATIONDETAILS displays details on evaluation of Automatic Data Optimization policies considered for Automatic Data Optimization tasks.
It also shows the job name that executes the policy, in case the policy was selected for execution. If the policy was not selected for execution, this view provides a reason.
Related View
USER_ILMEVALUATIONDETAILS displays details on evaluation of Automatic Data Optimization policies considered for Automatic Data Optimization tasks for a user. It also shows the job name that executes the policy, in case the policy was selected for execution. If the policy was not selected for execution, this view provides a reason.
Note:
Automatic Data Optimization is supported in Oracle Database 12c Release 2 multitenant environments.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Number that uniquely identifies a specific Automatic Data Optimization task |
|
|
|
|
|
Name of the Automatic Data Optimization policy |
|
|
|
|
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 |
|
|
|
|
Indicates whether the policy has been selected for execution on the object. If not, the reason for not being selected is listed. Possible values:
The value |
|
|
|
|
Name of the job in the case where the policy is selected for execution on this object |
|
|
|
|
Reserved for future use |
See Also:
“USER_ILMEVALUATIONDETAILS”
