Re: expdp - audit

  • From: Oscar Ofiana <oj.ofiana@xxxxxxxxx>
  • To: itakamran@xxxxxxxxxxxx
  • Date: Tue, 7 May 2013 16:38:49 +1000

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


Other related posts: