You can check DBA_DATAPUMP_SESSIONS view as follows: SELECT sid, serial# FROM v$session s, dba_datapump_sessions d WHERE s.saddr = d.saddr; You can also debug the running data pump job. http://kamranagayev.com/2013/03/11/debugging-data-pump-session/ Sincerely, Kamran Aghayev A. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of AMIT VERMA Sent: Tuesday, May 07, 2013 11:32 AM To: oracle-l Subject: expdp - audit hi all, any idea how to figure out know who runs expdp command from dba_ views. please help i am trouble somebody its blunder & we don't know that guy? -- Amit Verma v.amit84@xxxxxxxxx "Winning takes talent but it takes character to keep winning" -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l