Solaris 11.4
Oracle 12.2

Hi,
we have about 70 Schedueler jobs defined, which are starting in intervalls from 1 minute to about 1 month.
Sometimes (about 2 to 3 times a weeks) there are time-windows of about 1 to 60 minutes , in which none of the jobs are starting.
It seams that the time of these windows not to correlate with the starting of one specific job.

We have controlled by a cron-job (schedueler wouldn't work) some of the resources. see below.
it seams None of values or rise or fall of these resources to correlate with the windows, when no job can be started by the scheduler.

Where should I look, to find the reason, that the scheduler jobs didn't start timely?

the query we used to find these windows:
select (ACTUAL_START_DATE-REQ_START_DATE),REQ_START_DATE,ACTUAL_START_DATE from dba_SCHEDULER_JOB_RUN_DETAILS
where
(job_name like 'xxxxx%' or job_name like 'xxxxxxxx%')
and (ACTUAL_START_DATE-REQ_START_DATE) > interval '30' second order by REQ_START_DATE desc;

the values, which we observe:
select sum(a.value) from v$sesstat a, v$statname b where a.statistic# = b.statistic# and b.name = 'opened cursors current';

select count(*) as "OPEN CURSORS" from v$open_cursor ;

select count(*) from v$process ;

select count(*) from v$session;

select count(*) from v$lock;

select count(*) from gv$transaction;


Kind regards
Matthias Penzlin