On Fri, Aug 26, 2011 at 10:10 AM, mek s <sidi.bouzid.meknessy@xxxxxxxxx> wrote: > 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... > Check job status here SELECT owner_name, job_name, operation, job_mode, state, attached_sessions FROM dba_datapump_jobs WHERE job_name NOT LIKE 'BIN$%' ORDER BY 1,2; -- Marcin Przepiorowski http://oracleprof.blogspot.com -- //www.freelists.org/webpage/oracle-l