SELECT attach_id, -- ATTACH_ID NUMBER job_id, -- JOB_ID RAW(16) saddr, -- SADDR RAW(8) type -- TYPE VARCHAR2(14) FROM gv$datapump_session WHERE inst_id = USERENV('INSTANCE')