To find out impdp/expdp OS pid

set pages 200 set linesize 300 col vs.spid for a10 col SID format 9999 col vp.spid format 99999 col vs.PROGRAM format a35 col USERNAME format a20 col OSUSER format a10 col STATUS format a10 col MACHINE format a20 select /*+ RULE */ vp.inst_id "SID", vp.spid "OS PID", vs.sid, vs.program, vs.username, vs.osuser, vs.logon_time, vs.status, vs.module,vs.machine from gv$process vp, gv$session vs where vs.module like 'Data%' and vp.inst_id = vs.inst_id and vs.paddr = vp.addr order by vp.inst_id, vs.sid;