Oracle教程 2023-03-31

Oracle 视图 DBA_ILMRESULTS 官方解释，作用，如何使用详细说明

Oracle视图DBA_ILMRESULTS用于显示与数据库中的信息化管理规则（ILM）相关的现有执行结果。 DBA_ILMRESULTS视图列出了当执行规则时发生的事件，包括引起规则执行的趋势值、描述和开始时间，及其ILM解决方案的失败情况的情况下的失败消息。

使用方法：

要查询与ILM视图DBA_ILMRESULTS相关的现有执行结果，请使用以下表单之一：

SELECT * FROM dba_ilmresults;

或

SELECT FROM dba_ilmresults WHERE ;

其中，可以是：

NAME (规则名称)
START_TIME (规则执行开始时间)
END_TIME (规则执行结束时间)
DESCRIPTION (规则描述)
INDNAME (检查的趋势值)
ERRCODE (错误代码)
ERRMSG (错误消息)

而是SQL语言中WHERE子句可用的某种表达式，如NAME = ‘My_ILM_Rules’。

DBA_ILMRESULTS displays information on data movement-related Automatic Data Optimization jobs in the database.

Related View

USER_ILMRESULTS displays information on data movement-related Automatic Data Optimization jobs for tasks created by the user.

Note:

Automatic Data Optimization is supported in Oracle Database 12c Release 2 multitenant environments.

Column	Datatype	Description
`TASK_ID`	`NUMBER`	Number that uniquely identifies a specific Automatic Data Optimization task
`JOB_NAME`	`VARCHAR2(128)`	Name of the Automatic Data Optimization job
`JOB_STATE`	`VARCHAR2(35)`	State of the job. Possible values: `JOB CREATED` `COMPLETED SUCCESSFULLY` `FAILED` `STOPPED` `JOB CREATION FAILED` `DEPENDENT OBJECTS BEING REBUILT` `FAILED TO REBUILD DEPENDENT OBJECTS`
`START_TIME`	`TIMESTAMP(6)`	Start time of the Automatic Data Optimization job
`COMPLETION_TIME`	`TIMESTAMP(6)`	Completion time of the Automatic Data Optimization job
`COMMENTS`	`VARCHAR2(4000)`	Additional information in cases where the Automatic Data Optimization job execution fails
`STATISTICS`	`CLOB`	Job specific statistics, such as space saved via compression. This column is in the form of comma separated name / value pairs, with each pair representing a particular statistic name and value.