ORA-00060: Deadlock detected when using dbms_scheduler with scheduler ressource

Dear all,

Im Using Oracle 19.20 CDB with 2 PDB's.

I have a dbms_scheduler job in on of the pdb that starts up in different schemas at the same time. In order not to start so many jobs at the same time, I wanted to limit the number of this kind of jobs to 5 at the same time using a ressource queue. For this I created a scheduler resource.

BEGIN

 DBMS_SCHEDULER.create_resource (

   resource_name => 'jobxyz_resources',

   units        => 5,

   status       => 'ENFORCE_CONSTRAINTS', -- Default

   constraint_level => 'JOB_LEVEL');      -- Default

END;

/

Then I assigned all the jobs starting same time to this resource using a resource constraint.