Re: Oracle on Sun T2 performance problems

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Thu, 25 Sep 2008 09:48:01 -0400
Message-ID: <74f79c6b0809250648s71d9bfbfv5ced4c965e7b327d@mail.gmail.com>

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.

Finn

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.
>

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

Received on Thu Sep 25 2008 - 08:48:01 CDT

This message: [ Message body ]
Next message: Powell, Mark D: "RE: auditing code changes ?"
Previous message: Freeman, Donald: "RE: auditing code changes ?"
In reply to: Crisler, Jon: "RE: Oracle on Sun T2 performance problems"
Next in thread: Michael Moore: "Re: Developers need your help!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message