dbms_scheduler locks
i have a scenario that causes the scheduler to hang, and triggers an incident with an ORA-00600 error (in the incident trace files).
1. procedure A (ProcA) is scheduled to run a report at a certain time in the scheduler.
2. ProcA initiates a procedure B (ProcB) that, in turn,
3. schedules another procedure C (ProcC) to run immediately (we use this
mechanism to run a report as a background process, the report being run by
ProcC).
what *sometimes* happens is that
1. ProcA is run,
2. successfully initiates ProcB, which, in turn,
3. schedules ProcC with dbms_scheduler.create_job, and then
4. ProcC does not run (although it is visible in the schedule), and the entire
1. procedure A (ProcA) is scheduled to run a report at a certain time in the scheduler.
2. ProcA initiates a procedure B (ProcB) that, in turn,
3. schedules another procedure C (ProcC) to run immediately (we use this
mechanism to run a report as a background process, the report being run by
ProcC).
what *sometimes* happens is that
1. ProcA is run,
2. successfully initiates ProcB, which, in turn,
3. schedules ProcC with dbms_scheduler.create_job, and then
4. ProcC does not run (although it is visible in the schedule), and the entire
0