how to understand that the session is closed

Asked Sep 15 '14 at 03:38

Active Sep 15 '14 at 03:38

Viewed 49 times

After a forced stop job in dbms_sheduler session some time remains active, although the job has been stopped. How do you know that the session is closed, do not use v$session views.

I stop all jbos as

   FOR r IN (SELECT JOB_CLASS FROM JBSD$SCHEDULER_JOBS) LOOP
      dbms_scheduler.disable(name => 'SYS.'||r.JOB_CLASS, force => TRUE);
      dbms_scheduler.stop_job(job_name => 'SYS.'||r.JOB_CLASS, force => TRUE);
   END LOOP;

and throws an exception in function run the job to interrupt her

asked Sep 15 '14 at 03:38

Roman

What is the version up to four decimals? – Lalit Kumar B Sep 15 '14 at 03:46
Version is 11.2.0.3.0 – Roman Sep 15 '14 at 03:49
Set the trace on and see what exactly is going in the trace file. – Lalit Kumar B Sep 15 '14 at 05:09
Thank you all, in the end, decided to look at the session through v$session view. – Roman Sep 15 '14 at 10:22

how to understand that the session is closed

0 Answers0