RE: Data Pump and compression

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Fri, 28 Sep 2007 12:16:15 -0700 (PDT)
Message-ID: <670311.96023.qm@web38904.mail.mud.yahoo.com>

You can compress metadata AND/OR data with datapump. When I was testing it, I saw some pretty significant numbers on compression of database data. Don't have exact ones but well over 10-15%. (over 50% as I recall in my test).

Again the question is licensing. I'm not sure if this is covered in the compression license or not.

"Kerber, Andrew W." <Andrew.Kerber_at_umb.com> wrote:

> Shrinking the metadata wouldn't help a lot, its just
> not that big.
>
> We export through a pipe and use gzip to compress
> it, and get pretty
> good compression of standard export files, I expect
> it would work with
> datapump files also if you are only using one output
> file.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Rich Jesse
> Sent: Friday, September 28, 2007 9:28 AM
> To: oracle-l_at_freelists.org
> Subject: Re: Data Pump and compression
>
> That's very poor compression. I hope it's a typo in
> the docs! Anyone
> messed with this yet???
>
> Rich
>
> > Check out section 1.3.1 at
> >
>

http://download.oracle.com/docs/cd/B28359_01/server.111/b28279/chapter1.
> htm#FEATURENO06982
> >
> > "
> > Data Pump provides the ability to compress the
> metadata of a dump file
> set,
> > which can shrink the dump files by 10-15%.
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

> NOTICE: This electronic mail message and any
> attached files are confidential. The information is
> exclusively for the use of the individual or entity
> intended as the recipient. If you are not the
> intended recipient, any use, copying, printing,
> reviewing, retention, disclosure, distribution or
> forwarding of the message or any attached file is
> not authorized and is strictly prohibited. If you
> have received this electronic mail message in error,
> please advise the sender by reply electronic mail
> immediately and permanently delete the original
> transmission, any attachments and any copies of this
> message from your computer system. Thank you.
>
>

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

Robert G. Freeman
Author:
Now Available for Pre-Sales on Amazon.com!!!!

Oracle Database 11g New Features (Oracle Press)

Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

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

Received on Fri Sep 28 2007 - 14:16:15 CDT