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

VIEW: SYS.CDB_ILMRESULTS

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

Information on ILM jobs in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_ILMRESULTS;

Dependencies

[top of page]

SYS.CDB_ILMRESULTS does not reference any database object

SYS.CDB_ILMRESULTS is referenced by following:

SchemaPUBLIC
SynonymCDB_ILMRESULTS