Re: RMAN

From: Surachart Opun <surachart_at_gmail.com>
Date: Fri, 26 Aug 2011 15:27:19 +0700
Message-ID: <CALoQP5ew+d5NhnC4QRre4-VhDxZL-QRGtTK8rtCX9Gd6ZvtZ9A_at_mail.gmail.com>

What is top events in Statpack Report?
RMAN can make CPU % peak and high IO. You should not schedule in peak time. Data Pump also spend much I/O.

Surachart Opun
Oracle ACE, Contributor (Oracle User Group in Thailand) http://surachartopun.com
skye: surachart_op

On Fri, Aug 26, 2011 at 3:10 PM, mek s <sidi.bouzid.meknessy_at_gmail.com>wrote:

> Hello,
>
> Database : 11gR2
>
> I was recently provided an access to a new database, because users are
> complaining of poor perfromance.
> During my monitoring of this database, and using statspack report (because
> we don't have licensed diagnostics pack), I have seen both RMAN and Datapump
> processes running together during peak hours. So I asked the DBA , if she's
> scheduling RMAN and datapump together?
>
> She replied that she knows nothing about these datapump processes and that
> could be RMAN who is using (“ Module: Data Pump Worker”) !
> I never read that before in the Oracle documentation! Is it correct that
> RMAN utility can use Data Pump Workers??!
> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 26 2011 - 03:27:19 CDT