Re: RMAN

From: mek s <sidi.bouzid.meknessy_at_gmail.com>
Date: Fri, 26 Aug 2011 11:16:26 +0200
Message-ID: <CAJX5RkQtAvaW+g8BSMpcu8Y_4EQQzKX8CTYWP47L7XqFa5JZkA_at_mail.gmail.com>

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; no rows selected

On Fri, Aug 26, 2011 at 11:14 AM, Marcin Przepiorowski <pioro1_at_gmail.com>wrote:

> 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-l

Received on Fri Aug 26 2011 - 04:16:26 CDT