Re: RMAN backup slows database performance to a crawl

On Thu, Jul 10, 2008 at 1:16 PM, Finn Jorgensen <finn.oracledba_at_gmail.com> 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 http://jaredstill.com/articles.html

There's a couple pages on RATE and SET LIMIT

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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