Hi, if it was a Job, there is an entry in dba_scheduler_job_log. Bye Joerg Am 26.08.2011 um 11:31 schrieb "Niall Litchfield" <niall.litchfield@xxxxxxxxx>: > If it really happened at 12:00 am then it was almost certainly scheduled by a > human via a scheduling tool. Most of these will have log files (the difficult > bit will be working out whether it was cron, dba_scheduler, etc etc.) The > listener.log should tell you what program was used to connect at that time as > well. > > On Fri, Aug 26, 2011 at 10:20 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> > wrote: > The issue happened 23 of August at 12:00 am. dba_datapump_jobs returns no > rows. > > > On Fri, Aug 26, 2011 at 11:19 AM, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> > wrote: > Hi, > > If the datapump job is still running you can attach to it using expdp or > impdp (depending what is happening). > > The dba_datapump_jobs view will give you the information needed to connect. > > Regards, > > > Freek D'Hooge > Uptime > Oracle Database Administrator > email: freek.dhooge@xxxxxxxxx > tel +32(0)3 451 23 82 > http://www.uptime.be > disclaimer: www.uptime.be/disclaimer > --- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On > Behalf Of mek s > Sent: vrijdag 26 augustus 2011 11:11 > To: Niall Litchfield > Cc: ORACLE-L > Subject: Re: RMAN > > when datapump starts I can see DM processes in alert log file, like this: > > DM00 started with pid=53, OS id=18616, ..... > > How can I know at which time these processes finish? I cannot see something > like DM00 finished .... > > I want to know when datapump started and finished... > On Fri, Aug 26, 2011 at 11:08 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> > wrote: > No they are not in use, > Thank you > > On Fri, Aug 26, 2011 at 11:07 AM, Niall Litchfield > <niall.litchfield@xxxxxxxxx> wrote: > are transportable tablespaces in use IIRC they use data pump. > > On Fri, Aug 26, 2011 at 9:10 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> wrote: > I know That RMAN must access to V$ and GV$ views to extract some information > useful for backup process BUT, is RMAN using Data Pump Workers for that? > Thank you, > S > > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info > > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info