Re: Oracle on Sun T2 performance problems
Date: Thu, 25 Sep 2008 09:48:01 -0400
The dismal performance of RMAN compression in 10g is a pretty well-known issue. Supposedly this is much better in 11g, but I have not had a chance to test that.
On Wed, Sep 24, 2008 at 10:56 AM, Crisler, Jon <Jon.Crisler_at_usi.com> wrote:
> We seem to have narrowed down the performance issue. The database has a
> high percentage of LOBs, and the performance problem occurs when using RMAN
> compression. If I run a RMAN inc0 backup with compressed backupsets on this
> 150gb database, with 2 channels, it takes 21 hours. With 8 channels it
> takes 12+ hours and no performance gains are to be had with more than 8
> channels. If I turn off compression, I can run the backup in 30 minutes
> !! The resulting backups are 120gb in size, compared to 68 gb with rman
> compression. I need to delve into this further.