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