SELECT
inst_id, -- INST_ID NUMBER
kupvaid, -- ATTACH_ID NUMBER
kupvajobid, -- JOB_ID RAW(16)
kupvasesaddr, -- SADDR RAW(8)
decode( -- TYPE VARCHAR2(14)
kupvasestype,1,'DBMS_DATAPUMP',2,'MASTER',3,'WORKER', 4,'EXTERNAL TABLE','OTHER')
FROM
x$kupva