Ghost Job in DBA_SCHEDULER_RUNNING_JOBS Does Not Let AQ to Submit New PL/SQL/NTFN Job

(Doc ID 2274785.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 12.2]
Information in this document applies to any platform.


Scheduler job does not work as expected when ORA-4031 is reported due to lack of memory.

In such case a running scheduler job dies suddenly, however its entry is still shown in DBA_SCHEDULER_RUNNING_JOBS. This is like a GHOST entry.

The presence of ghost job in DBA_SCHEDULER_RUNNING_JOBS does not let AQ to submit any new plsql ntfn job, as a result messages remains in ready state and notifications are not sent.

But there is no session ID and no process ID associated with the job.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms