Monday, October 26, 2020
    Home Oracle DBA Tips Compression in Datapump of Oracle 11g

    Compression in Datapump of Oracle 11g

    Compression feature of Oracle 11g Datapump

    The ability to constrict the meta-data associated with a Information Push job was first provided in Oracle Data source 10g Launch 2. In Oracle Data source 11g, this pressure capability has been extended so that desk data can be compacted on trade.

    Data Pump compression is an in-sequence process, so the decreased dump file size denotes an important savings in disk space. Dissimilar operating system or file system compression methods, Data Pump compression is entirely in order on the import side as well, so there is no require to uncompress a dump file before importing it. The compressed dump file sets are robotically decompressed throughout import devoid of any extra steps by the Database Administrator.

    - Advertisement -

    Full Information Push performance is available using a compacted data file. Any control that is used on a regular data file will also work on a compacted data file. Users have the following options to determine which parts of a dispose of information file set should be compressed:

    ALL enables pressure for the whole trade function.

    DATA-ONLY outcomes in all data being published to the dispose of information file in compacted structure.

    METADATA-ONLY outcomes in all meta-data being published to the dispose of information file in compacted structure. This is the standard.

    - Advertisement -

    NONE immobilizes compression for the whole export process.

    The decrease in dump file size will differ based on data types and other things. Note that when importing using Data Pump, the CREATE TABLE statements will have compression clauses that match the explanation in the export file. If a compression clause is missing, then the table comes into the COMPRESSION characteristics of the tablespace where the table is stored.

    In Oracle Database 11g, Oracle provides the mechanism to compress both data and metadata during the extract operation. The available options for the COMPRESSION parameter are as follows:

    compression={all | data_only | metadata_only | none}

    Following is an example:

    $expdp full=yes userid=”‘/ as sysdba'”  dumpfile=dbadir:full.compress.dmp compression=all

    - Advertisement -
    - Advertisment -

    Most Popular

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Differences Raw Device, ASM Device and CFS

    The article explains basic differences of ASM device, raw device and Oracle cluster file system cfs with fundamentals

    Recent Comments