You can also check DBA_DATAPUMP_JOBS, similar to: SQL> select owner_name, operation, job_mode, state from dba_datapump_jobs; Hth, OJ On Tue, May 7, 2013 at 4:36 PM, Kamran Agayev (ICT/SNO) < itakamran@xxxxxxxxxxxx> wrote: > 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 > > > -- //www.freelists.org/webpage/oracle-l