In DBMS_JOBS_RUNNING you can find the sid of the session.
Use this sid to identify the session in v$session and kill the session with:
'alter system kill session 'sid,serial#';'
Don't forget to mark the job as broken or remove it from the job queue.
|
Results 1 to 2 of 2
Threaded View
|
Click Here to Expand Forum to Full Width |