GV$SCHEDULER_RUNNING_JOBS definition in Oracle Database 11.2
GV$SCHEDULER_RUNNING_JOBS

select
  inst_id,                                 -- INST_ID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  session_serial_num,                      -- SESSION_SERIAL_NUM NUMBER
  job_id,                                  -- JOB_ID NUMBER
  paddr,                                   -- PADDR RAW(8)
  os_process_id,                           -- OS_PROCESS_ID VARCHAR2(12)
  CAST (                                   -- SESSION_STAT_CPU INTERVAL DAY(2) TO SECOND(3)
    numtodsinterval(session_stat_cpu/100, 'second') AS INTERVAL DAY(3) TO SECOND(2)) session_stat_cpu 
from
  x$jskslv

home |  up