SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_SCHEDULER_GROUPS

Line 457: from dba_scheduler_groups group by group_type order by 1)

453: for it in (
454: select group_type t, count(*) n , round(avg(number_of_members)) a ,
455: max(number_of_members) b,
456: median(number_of_members) c
457: from dba_scheduler_groups group by group_type order by 1)
458: loop
459: sum1 := sum1 || ',G' || substr(it.t,1,3) || 'N:' || it.n
460: || ',G' || substr(it.t,1,3) || 'A:' || it.a
461: || ',G' || substr(it.t,1,3) || 'X:' || it.b