Database Administration (MOSC)

MOSC Banner

dbms_scheduler locks

edited Jul 20, 2009 8:25PM in Database Administration (MOSC) 9 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center