One of our replication jobs won't complete because of a job queue lock. Have tried dbms_job.broken, but seems to wait until job completes. Killing the sessions did not release the job queue lock nor completed the job.
How do we force to release a "JQ" lock?
Is there a way to kill SNP processes at the OS level (Windows NT)?
Any advice or suggestion highly appreciated.