oracle新版导出dump压缩比例,Oracle 12c 新特性 --- 根据COMPRESSION_ALGORITHM参数值来确定导出dumpfile的压缩级别...

概念

There is a new expdp command-line option for Oracle Data Pump Export to control the degree of compression used for a Oracle Data Pump dump file. It also adds the same options to the PL/SQL DBMS_DATAPUMP package. This allows the DBA to trade off time spent compressing data against the size of the Oracle Data Pump dump file.

This feature allows the DBA to control the resources used during an export operation.

有一个新的expdp命令行选项，用于Oracle数据泵导出，以控制用于Oracle数据泵转储文件的压缩程度。它还为PL / SQL DBMS_DATAPUMP包添加了相同的选项。这使得DBA可以利用时间来压缩与Oracle数据泵转储文件大小的压缩数据。

这个特性允许DBA控制在导出操作过程中使用的资源。

目的：https://www.cndba.cn/leo1990/article/2063

Specifies the compression algorithm to be used when compressing dump file data.

指定压缩转储文件数据时使用的压缩算法。

语法及描述：

https://www.cndba.cn/leo1990/article/2063

COMPRESSION_ALGORITHM = {BASIC | LOW | MEDIUM | HIGH}

The parameter options are defined as follows:

BASIC--Offers a good combination of compression ratios and speed; the algorithm used is the same as in previous versions of Oracle Data Pump.

LOW---Least impact on export throughput and suited for environments where CPU resources are the limiting factor.

MEDIUM---Recommended for most environments. This option, like the BASIC option, provides a good combination of compression ratios and speed, but it uses a different algorithm than BASIC.

HIGH--Best suited for situations in which dump files will be copied over slower networks where the limiting factor is network speed.

The performance of a compression algorithm is characterized