SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_SCHEDULER_WINDOWS

Line 316: select window_priority t, count(*) n from dba_scheduler_windows

312: -- Number of high priority windows (low = total - high)
313: -- Number of windows without a resource plan
314: -- Number of named schedule based windows (inlined schedule = total - named schedule)
315: for it in (
316: select window_priority t, count(*) n from dba_scheduler_windows
317: group by window_priority order by 1)
318: loop
319: sum1 := sum1 || ',WIP' || substr(it.t,1,2) || ':' || it.n;
320: end loop;

Line 322: select count(*) into n1 from dba_scheduler_windows where resource_plan is

318: loop
319: sum1 := sum1 || ',WIP' || substr(it.t,1,2) || ':' || it.n;
320: end loop;
321:
322: select count(*) into n1 from dba_scheduler_windows where resource_plan is
323: null;
324: sum1 := sum1
325: || ',WINR:' || n1;
326:

Line 331: dba_scheduler_windows) group by st order by 1)

327: for it in (
328: select st t, count(*) n from
329: (select schedule_type st
330: from
331: dba_scheduler_windows) group by st order by 1)
332: loop
333: sum1 := sum1 || ',SWT' || substr(it.t,1,2) || ':' || it.n;
334: end loop;
335: