DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ILMRESULTS

Object Details
Object Name: DBA_ILMRESULTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information on ILM jobs

[View Source]

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER

Number that uniquely identifies a specific ILM task
JOB_NAME VARCHAR2 (128) Yes Job name for executing policies
JOB_STATE VARCHAR2 (35)
State of the Job
START_TIME TIMESTAMP(6) (11)
Time of start of the job
COMPLETION_TIME TIMESTAMP(6) (11)
Time of completion of the job
COMMENTS VARCHAR2 (4000)
More information if the job failed
STATISTICS CLOB (4000)
ILM job related statistics
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TASK_ID
,      JOB_NAME
,      JOB_STATE
,      START_TIME
,      COMPLETION_TIME
,      COMMENTS
,      STATISTICS
FROM SYS.DBA_ILMRESULTS;

Dependencies

[top of page]

SYS.DBA_ILMRESULTS references the following:

SchemaSYS
TableILM_EXECUTION$
TableILM_RESULTS$
SYS.DBA_ILMRESULTS is referenced by following:

SchemaPUBLIC
SynonymDBA_ILMRESULTS