select
  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)
  session_stat_cpu                         -- SESSION_STAT_CPU INTERVAL DAY(2) TO SECOND(3)
from
  gv$scheduler_running_jobs
where
  inst_id = USERENV('Instance')