RE: Data Pump and compression
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: Andrew.Kerber@xxxxxxx, rjoralist@xxxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 28 Sep 2007 12:16:15 -0700 (PDT)
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.
RF
--- "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Rich Jesse
> Sent: Friday, September 28, 2007 9:28 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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%.
> >
>
>
> --
> //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.
>
>
==============================================================================
>
> --
> //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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
