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