5.102 DBA_ILMRESULTS
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 | NULL | Description |
---|---|---|---|
|
|
|
Number that uniquely identifies a specific Automatic Data Optimization task |
|
|
|
Name of the Automatic Data Optimization job |
|
|
|
State of the job. Possible values:
|
|
|
|
Start time of the Automatic Data Optimization job |
|
|
|
Completion time of the Automatic Data Optimization job |
|
|
|
Additional information in cases where the Automatic Data Optimization job execution fails |
|
|
|
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. |
See Also: