[Home] [Help]
VIEW: SYS.DBA_WI_JOBS
Source
View Text - Preformatted
select j.jobid,
j.jobname,
j.path,
m.modelorder,
m.threshold
from wi$_job j,
wi$_frequent_pattern_metadata m
where j.jobid = m.jobid (+)
View Text - HTML Formatted
SELECT J.JOBID
,
J.JOBNAME
,
J.PATH
,
M.MODELORDER
,
M.THRESHOLD
FROM WI$_JOB J
,
WI$_FREQUENT_PATTERN_METADATA M
WHERE J.JOBID = M.JOBID (+)