Oracle Data Pump Performance comparison of different working modes (i) test environment

According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain export, import performance differences.

This article introduces the test environment.

Both the source and target database versions are 10.2.0.3, there is no version difference, the character set is ZHS16GBK, the national character set is the AL16UTF16 character set, the source and target databases are 16k block_size, Therefore, there are no problems with the way the table space is migrated:

Sql> SELECT global_name from Global_name;

Global_name

------------------------------------------------------------------------

Newdemo

Sql> SELECT * from V$version;

BANNER

----------------------------------------------------------------

Oracle database10genterpriseedition Release10.2.0.3.0-64bi

Pl/sql Release 10.2.0.3.0-production

CORE 10.2.0.3.0 Production

TNS for Linux:version 10.2.0.3.0-production

Nlsrtl Version 10.2.0.3.0-production

Sql> SELECT Property_name, Property_value

2 from Database_properties

3 WHERE property_name like '%characterset ';

Property_name Property_value

------------------------------ --------------------------------------------------

Nls_characterset ZHS16GBK

Nls_nchar_characterset AL16UTF16

Sql> Show PARAMETER Db_block_size

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Db_block_size integer 16384

Above is the query result of the source database, the query result of the target database is identical, except Global_name:

Sql> SELECT global_name from Global_name;

Global_name

----------------------------------------------------------------------------

Tjsq

Sql> SELECT * from V$version;

BANNER

----------------------------------------------------------------

Oracle database10genterpriseedition Release10.2.0.3.0-64bi

Pl/sql Release 10.2.0.3.0-production

CORE 10.2.0.3.0 Production

TNS for Linux:version 10.2.0.3.0-production

Nlsrtl Version 10.2.0.3.0-production

Sql>colproperty_value FORMAT A50

Sql> SELECT Property_name, Property_value

2 from Database_properties

3 WHERE property_name like '%characterset ';

Property_name Property_value

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

------------------------------ --------------------------------------------------

Nls_characterset ZHS16GBK

Nls_nchar_characterset AL16UTF16

Sql> Show PARAMETER Db_block_size

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Db_block_size integer 16384

The data to migrate is distributed in two tablespaces:

Sql> SELECT tablespace_name, file_name, bytes/1024/1024/1024