Re: RMAN
From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Fri, 26 Aug 2011 10:14:59 +0100
Message-ID: <CAGdek=wwttjYZ__f0Rh=u0eGv2orH=+OCkGM+xXEOnLg30sAgg_at_mail.gmail.com>
On Fri, Aug 26, 2011 at 10:10 AM, mek s <sidi.bouzid.meknessy_at_gmail.com> 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...
>
Date: Fri, 26 Aug 2011 10:14:59 +0100
Message-ID: <CAGdek=wwttjYZ__f0Rh=u0eGv2orH=+OCkGM+xXEOnLg30sAgg_at_mail.gmail.com>
On Fri, Aug 26, 2011 at 10:10 AM, mek s <sidi.bouzid.meknessy_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 26 2011 - 04:14:59 CDT