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(4) os_process_id, -- OS_PROCESS_ID VARCHAR2(12) CAST (numtodsinterval (session_stat_cpu/100, 'second') -- SESSION_STAT_CPU INTERVAL AS INTERVAL DAY (3) TO SECOND (2)) session_stat_cpu from x$jskslv

home |  up  |  mailbox