View all running jobs: SELECT a.sid, c.serial#, a.job, a.failures, to_char(a.this_date, ‘mm/dd/yyyy hh:mi pm’) startdatetime, b.what FROM dba_jobs_running a, dba_jobs b, v$session c WHERE a.job = b.job AND a.sid = c.sid order by a.this_date; SID SERIAL# JOB FAILURES STARTDATETIME WHAT ———- ———- ———- ———- ——————- ——————————————————————————– 590 18375 228 1 04/27/2011 01:00 am activity_accumulator_update; Kill a job (Connect as SYSTEM): alter system kill session ‘sid, serial#’ example: alter system kill session ‘590, 18375’;]]>
