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