Re: RMAN

  • From: Surachart Opun <surachart@xxxxxxxxx>
  • To: sidi.bouzid.meknessy@xxxxxxxxx
  • Date: Fri, 26 Aug 2011 15:27:19 +0700

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@xxxxxxxxx>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
>
  • References:

Other related posts: