Re: RMAN backup slows database performance to a crawl

From: Jared Still <>
Date: Thu, 10 Jul 2008 14:14:18 -0700
Message-ID: <>

On Thu, Jul 10, 2008 at 1:16 PM, Finn Jorgensen <> wrote:

> Checking an AWR report I noticed that the "Av Rd(ms)" column of the
> tablespace IO stat for that tablespace is at 671ms (Yikes!) when the
> RMAN job is running and a much more normal 3.6ms when it's not.

How many channels are being used?

You may want to reduce the # of channels if > 1.

You can use the 'SET LIMIT' command to slow down RMAN. (it's mostly undocumented)

See "Making RMAN Perform' at

There's a couple pages on RATE and SET LIMIT

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Thu Jul 10 2008 - 16:14:18 CDT

Original text of this message