[Home] [Help]
53: for it in (
54: select jt t, count(*) n from
55: (select program_type jt
56: from dba_scheduler_jobs j,
57: dba_scheduler_programs p
58: where
59: job_type is null
60: and p.owner = j.program_owner
61: and p.program_name = j.program_name
64: from dba_scheduler_jobs j
65: where
66: j.job_type is null
67: and not exists (select 1 from
68: dba_scheduler_programs p
69: where
70: p.owner = j.program_owner
71: and p.program_name = j.program_name)
72: union all
230: -- Per type program numbers, i.e. the number of executable, plsql_block,
231: -- stored procedure, chain programs
232:
233: for it in (
234: select program_type t, count(*) n from dba_scheduler_programs
235: group by program_type order by 1)
236: loop
237: sum1 := sum1 || ',PRT' || substr(it.t,1,3) || ':' || it.n;
238: end loop;
243: select count(*) , round(avg(number_of_arguments)) ,
244: median(number_of_arguments) ,
245: max(number_of_arguments)
246: into n1, n2, n3, n4
247: from dba_scheduler_programs where number_of_arguments > 0;
248: sum1 := sum1
249: || ',PAC:' || n1
250: || ',PAA:' || n2
251: || ',PAM:' || n3
385: select step_type t, count(*) n from
386: (select step_type from dba_scheduler_chain_steps
387: where step_type <> 'PROGRAM'
388: union all
389: select program_type from dba_scheduler_programs p,
390: dba_scheduler_chain_steps s
391: where
392: s.step_type = 'PROGRAM' and
393: s.program_owner =p.owner and