Database Administration (MOSC)

MOSC Banner

DBMS_SCHEDULER error deadlock

edited Apr 10, 2019 5:01AM in Database Administration (MOSC) 12 commentsAnswered

I am running into an issue scheduling jobs via DBMS_SCHEDULER, where I get the errors:

ORA-20001: schedule_job: ORA-04020: deadlock detected while trying to lock object SYS.SCHEDULER$_EVENT_QUEUE, FORMAT_ERROR_BACKTRACE: ORA-06512: at "SYS.DBMS_ISCHED", line 8210

ORA-06512: at "SYS.DBMS_SCHEDULER", line 4353

This happens on two of our databases. However, when I rung the exact same code as SYS, it starts working for all users but eventually will be tossing the above errors again.

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