RE: Data Pump and compression

From: Vishal Gupta <vishal_at_vishalgupta.co.uk>
Date: Tue, 2 Oct 2007 10:37:37 +0100
Message-ID: <02197E405596A24997FDA8481FDBE9D12554@vishalgupta.vishalgupta.co.uk>

10-15% compression mentioned in documentation is only for metadata and then doc goes on to say that compress has been added at data level as well in 11g. So definitely compress ratio will lot higher with data compression.

Regards,
Vishal Gupta

From: oracle-l-bounce_at_freelists.org on behalf of Robert Freeman Sent: Fri 28/09/2007 20:16
To: Andrew.Kerber_at_umb.com; rjoralist_at_society.servebeer.com; oracle-l_at_freelists.org Subject: RE: Data Pump and compression

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 



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

Received on Tue Oct 02 2007 - 04:37:37 CDT