Re: RMAN backup slows database performance to a crawl

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: finn.oracledba@xxxxxxxxx
  • Date: Thu, 10 Jul 2008 14:14:18 -0700

On Thu, Jul 10, 2008 at 1:16 PM, Finn Jorgensen <finn.oracledba@xxxxxxxxx>
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

Other related posts: