Good day. recently the Mobile_Cleanup_Sys.Clean_Faulty_Sync_Tasks__ is never completing and just keeps executing. We try and kill the job, but it wont stop.
I tried setting the error fag on the front end (IEE) and it wont allow me to set this job as an error or stop the job.
We tried placing this in its own batch queue to keep it from jamming up the queue and adding more processes to its queue and it just kicked off more of these jobs that will not complete.
We are running APPS9 UD14 and mWO.
Where to look to diagnose and resolve this issue and how can you kill a process that wont die?
Best answer by Chathuranga Samarakoon
LPAD(' ', (level-1)*2, ' ') || NVL(s.username, '(oracle)') AS username,
TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time
FROM v$session s
WHERE level > 1
OR EXISTS (SELECT 1
WHERE blocking_session = s.sid)
CONNECT BY PRIOR s.sid = s.blocking_session
START WITH s.blocking_session IS NULL