Data Pump and compression

Mailing List

Home

Forum Home

Oracle List - by freelists.org

Oracle on SUSE Linux - Runing Oracle on SUSE Linux

Oracle database error code ...

www.freelists.org

Subjects

•	ORA 12540: TNS:internal limit restriction exceeded
•	ORA 12838 please : Is possible to append two times to the same table befo
•	ORA 12838 please : Is possible to append two times to the same table before
•	ora 04031
•	ora 12500 on windows
•	ORA 32004: obsolete and/or deprecated parameter(s) specified
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ora 12500 on windows
•	ORA 01650, one idea
•	ORA 01650
•	ORA 4030
•	ORA 12838 please : Is possible to append two times to thesametable before do
•	ORA 12838 please : Is possible to append two times to thesame table before d
•	ORA 01536
•	ORA 03113 end of file on communication channel
•	ORA 32004: obsolete and/or deprecated parameter(s) specified
•	ORA 00600:
•	ORA 00020: maximum number of processes (%s) exceeded
•	ORA 01925: maximum of 30 enabled roles exceeded
•	ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
•	ora 12500 on windows
•	ora 12500 on windows
•	ora 12500 on windows
•	ORA 01650, one idea
•	ora 12500 on windows
•	ora 12500 on windows
•	ora 12500 on windows
•	ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
•	ORA 01650, one idea
•	ORA 01650, one idea
•	ORA 01650, one idea
•	ORA 01650
•	ORA 01650
•	ORA 01031
•	ORA 4030
•	ORA 4030
•	ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
•	ORA 01722 invalid number

Data Pump and compression

Data Pump and compression

2007-10-02 - By Vishal Gupta

Back

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@(protected) on behalf of Robert Freeman
Sent: Fri 28/09/2007 20:16
To: Andrew.Kerber@(protected); rjoralist@(protected); oracle-l@(protected)
.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.

RF

--- "Kerber, Andrew W." <Andrew.Kerber@(protected)> 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@(protected)
> [mailto:oracle-l-bounce@(protected)] On Behalf Of
> Rich Jesse
> Sent: Friday, September 28, 2007 9:28 AM
> To: oracle-l@(protected)
> 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

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.6944.0">
<TITLE>RE: Data Pump and compression</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText28364 dir=ltr>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>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.</DIV>
<DIV dir=ltr> </DIV></DIV>
<DIV id=idSignature42173 dir=ltr>
<DIV>Regards,</DIV>
<DIV>Vishal Gupta</DIV></DIV>
<DIV dir=ltr> 
<HR tabIndex=-1>
From: oracle-l-bounce@(protected) on behalf
of
Robert Freeman Sent: Fri 28/09/2007 20:16 To:
Andrew.Kerber@(protected); rjoralist@(protected);
oracle-l@(protected) Subject: RE: Data Pump and
compression </DIV>
<DIV>
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@(protected)>
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@(protected) > [<A
href="mailto:oracle-l-bounce@(protected)">mailto:oracle-l-bounce@(protected)
.org</A>]
On Behalf Of > Rich Jesse > Sent: Friday, September 28, 2007 9:28 AM > To: oracle-l@(protected) > 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 > > > <A
href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28279/chapter1"
>http://download.oracle.com/docs/cd/B28359_01/server.111/b28279/chapter1</A>.
 > 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%. >
> > > > -- > <A
href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</A>
 > > >
 > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
-- ---
 > 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. > > ========================================================================
======
 > > -- > <A
href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</A>
 > > >
 
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: <A
href="http://robertgfreeman.blogspot.com">http://robertgfreeman.blogspot.com</A
>
(Oracle Press) -- <A
href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</A>
 </DIV>

</BODY>
</HTML>