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