rman compressed backup is much smaller but very slow

From: Tomi Wijanto <restomi_w_at_yahoo.com>
Date: Wed, 2 Aug 2006 01:37:37 -0700 (PDT)
Message-ID: <20060802083737.29661.qmail@web52003.mail.yahoo.com>

Dear expert,

i tried compressed backup in 10g RMAN and very curious about its performance.
OS: AIX 5.3 ML04
CPU: 12 with dual core
MEMORY: 60GB
Datafiles were raw partition, backup directory were mounted with Concurrent IO.

If i ran the backup of 1 datafile without compression to disk, it took 45 seconds with backup size 5.17 GB. If i ran the same backup with compression, it took 290 seconds with backup size 838 MB.
So it's about 6 times slower.

Some presentation i read (one from Mr. Antognini) show that the overhead of compression is small, only about 15%.
Could someone shared their experieces on compressed backup, especially with big sized database.

regards,
tomi

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Wed Aug 02 2006 - 03:37:37 CDT