SQL> set linesize 154
SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       314         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=314;

   SERIAL#
----------
         1

SQL> alter system kill session '314, 1';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> /

no rows selected

SQL> /

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       249         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=249;

   SERIAL#
----------
     17175

SQL> alter system kill session '249, 17175';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> /

no rows selected

SQL> /

no rows selected

SQL> /

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       238         11 05.07.2010-15:13:04          0


SQL> select serial# from v$session where sid=238;

   SERIAL#
----------
     15708

SQL> alter system kill session '238, 15708';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> /

no rows selected

SQL> /

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       241         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=241;

   SERIAL#
----------
     63372

SQL> alter system kill session '241, 63372';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> /

no rows selected

SQL> /

no rows selected

SQL> /

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       241         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=241;

   SERIAL#
----------
     63431

SQL> alter system kill session '241, 63431';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       233         11 05.07.2010-15:13:04          0

SQL> select status from v$session where sid=233;

STATUS
--------
ACTIVE

SQL> select serial# from v$session where sid=233;

   SERIAL#
----------
      6048

SQL> alter system kill session '233, 6048';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       235         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=235;

   SERIAL#
----------
      5961

SQL> alter system kill session '235, 5961';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> /

no rows selected

SQL> /

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       235         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=235;

   SERIAL#
----------
      6086

SQL> alter system kill session '235, 6086';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       243         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=243;

   SERIAL#
----------
     43598

SQL> alter system kill session '243, 43598';

System altered.

SQL> 
SQL>  select sid, job, last_date, instance from dba_jobs_running where job=11;

       SID        JOB LAST_DATE             INSTANCE
---------- ---------- ------------------- ----------
       232         11 05.07.2010-15:13:04          0

SQL> select serial# from v$session where sid=232;

   SERIAL#
----------
     10723

SQL> alter system kill session '232, 10723';

System altered.

SQL> select sid, job, last_date, instance from dba_jobs_running where job=11;

no rows selected

SQL> /

no rows selected

SQL> /

no rows selected


  1* select job, what from dba_jobs
SQL> /

       JOB WHAT
---------- --------------------------------
        13 berka_MEAGREAD_rechte;
        11 berka_analyze_tables;	   --- Concerned Job
         5 grow_tables(1000000000);
      1469 mr_spy.pkg_schedule.schedule;
         3 statspack.snap;