技术博客 数据库、运维与工程实践笔记

DataPump Import (IMPDP) Performance Known Problems (文档 ID 1948188.1)

2024-03-24Oracle / RAC / RMAN

![1756814616718-6defddf6-331d-4af9-8d36-b64d812e3253.png](https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=euoj6tk0_9&_afrLoop=187944712729144#) | !1756814616782-cebc2ffd-fb4b-4d89-986a-98838ceb2fea.gif | DataPump Import (IMPDP) Performance Known Problems (文档 ID 1948188.1) |

—
—

1756814616782-cebc2ffd-fb4b-4d89-986a-98838ceb2fea.gif

| Goal
—

| Solution
—

| 1. General DataPump Import performance issues
—

| 2. Known DataPump Import performance issues detected while loading a particular object type
—

| [**3. Known DataPump Import performance issues caused by a specific DP parameter

**](https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=euoj6tk0_9&_afrLoop=187944712729144#aref_section23)
—

| References
—

APPLIES TO:

GOAL

This note will help you to identify the DataPump import (IMPDP) performance known problems. Please follow the referenced notes below to identify if you hit a known problem.

SOLUTION

1. General DataPump Import performance issues

[Note 1596645.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1596645.1) - EXPDP And IMPDP Slow Performance In 11gR2 and 12cR1 And Waits On Streams AQ: Enqueue Blocked On Low Memory, **Affected Version:** 11.2.0.1 to 12.1.0.2
[Note 1448360.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1448360.1) - Datapump Hangs With Status DEFINING, **Affected Version:** 10.2.0.1 and later

2. Known DataPump Import performance issues detected while loading a particular object type

  • PARTITION
[Note 1073195.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1073195.1) - DataPump Import (IMPDP) Is Slow When Importing Partitioned Tables, **Affected Version:** 10.1.0.2 to 11.2.0.1
[Note 1681444.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1681444.1) - DataPump Import (IMPDP) In Parallel Is Slow When Importing Partitioned Tables, **Affected Version:** 10.1.0.2 to 12.1.0.1 
[Note 1327029.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1327029.1) - DataPump Performance: Impdp Slow When Importing Partitioned Table, **Affected Version:** 11.2.0.2.0 and later
[Note 952853.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=952853.1) - IMPDP Performs Extremely Slow When Importing In Parallel Into An Existing Partitioned Table, **Affected Version:** 10.2.0.4 to 11.2.0.1
[Note 867678.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=867678.1) - Slow DataPump Import (IMPDP) From Tables With Many Subpartitions, **Affected Version:** 11.1.0.7
[Note 2014960.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=2014960.1) - Slow DataPump Import (IMPDP) For A Partitioned Table, **Affected Version:** 11.2.0.3 to 11.2.0.4
  • Constraint
RAC specific: [Note 2056924.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=2056924.1) - DataPump Import May Slow Down Due To "RAC: constraint DDL lock" Waits , **Affected Version:** 11.2.0.3 to 12.1.0.2
  • Domain Index
 [Note 1948129.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1948129.1) - DataPump Import (IMPDP) Is Very Slow for DOMAIN_INDEX, **Affected Version:** 10.1.0.2 and later
  • INDEX
  [Note 1459833.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1459833.1) - Datapump Expdp and Impdp slow in 11.2.0.3 as a result of Queries on SYS.KU$_INDEX_VIEW KU$, **Affected Version:** 11.2.0.3
  • Index Organized table (IOT)
 [Note 780784.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=780784.1) - Datapump Import (IMPDP) With TABLE_EXISTS_ACTION=TRUNCATE Is Slower When Table Exists, **Affected Version:** 10.2.0.1 and later
  • Grants / Roles
 [Note 414042.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=414042.1) - Expdp/Impdp Of Grants Takes Extremeley Long Time, **Affected Version:** 10.1.0.5 and later
 [Note 1267951.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1267951.1) - DataPump Import (IMPDP) is Very Slow at Object/System/Role Grants, Default Roles, **Affected Version:** 10.2.0.1 to 11.2.0.2
  • LOBs
 [Note 1467662.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1467662.1) - DataPump Export/Import Of LOBs Are Not Executed in Parallel, **Affected Version:** 10.2.0.1 to 11.2.0.4 
 [Note 1488229.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1488229.1) - Performance Problems When Transferring LOBs Using IMPDP With NETWORK_LINK, **Affected Version:** 10.1.0.3 to 11.2.0.4
 [Note 1590012.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1590012.1) - Impdp Takes Forever On Tables With Lobs, **Affected Version:** 11.2.0.3 and later
 [Note 803095.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=803095.1) - DataPump Import Of XMLTYPE And/Or LOBs Very Slow, **Affected Version:** 10.2.0.4 and later
 [Note 1365417.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1365417.1) - Performance of Securefiles Slow Using Datapump Import With Mutiple Lobs in a Table, **Affected Version:** 11.2.0.2 and later
  • TABLE_DATA
[Note 789700.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=789700.1) - DataPump Import (IMPDP) Seems To Hang On Processing Object Type SCHEMA_EXPORT/TABLE/TABLE_DATA, **Affected Version:** 10.2.0.3 to 11.1.0.6
  • TABLE_STATISTICS
  [Note 463322.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=463322.1) - DataPump Import (IMPDP) Hangs On TABLE_STATISTICS, **Affected Version:** 10.2.0.1 to 10.2.0.3
  • XLA Package Bodies
 [Note 1591131.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1591131.1) - XLA Package Bodies Are Much Slower To Import Into An 11.2.0.1 Database Than Into A 10.2.0.5 Database, **Affected Version:** 11.2.0.1 and later
  • Package Bodies
 [Note 1452917.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1452917.1) - DataPump Import Is Extremely Slow When Importing Package Bodies, **Affected Version:** 11.2.0.2 to 11.2.0.3
 [Note 1611223.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1611223.1) - DataPump Import Of Large Number Of Package Bodies Is Extremely Slow In 11.2.0.3, **Affected Version:** 11.2.0.3
  • Procedural Objects (PROCOBJ)
 [Note 1535530.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1535530.1) - Data Pump import (IMPDP) is very slow when importing PROCOBJ, Affected version: 11.2.0.3 and later, **Affected Version:** 11.2.0.3 and later
  • SDO Geometry
  [Note 469573.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=469573.1) - DataPump Import (IMPDP) Using A Network_Link For Table With Datatype SDO_GEOMETRY Is Very Slow, **Affected Version:** 10.1.0.2 and later
  • XMLType
 [Note 803095.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=803095.1) - DataPump Import Of XMLTYPE And/Or LOBs Very Slow, Affected Version: 10.2.0.4 and later
 [Note 1410113.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1410113.1) - Datapump Import is very slow importing into a Table with an XMLTYPE column, Version: 11.1.0.7 to 11.2.0.1, **Affected Version:** 11.1.0.7 to 11.2.0.1

**3. Known DataPump Import performance issues caused by a specific DP parameter

**

  • NETWORK_LINK
 [Note 1439691.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1439691.1) - DataPump Import (IMPDP) Over NETWORK_LINK Is Sometimes Very Slow, **Affected Version:** 11.2.0.1 and later
 [Note 392689.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=392689.1) - Datapump DB Link Import Is Very Slow at Estimate Phase When PARALLEL_MAX_SERVERS>0, **Affected Version:** 10.2.0.1 to 11.1.0.6
 [Note 469573.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=469573.1) - DataPump Import (IMPDP) Using A Network_Link For Table With Datatype SDO_GEOMETRY Is Very Slow, **Affected Version:** 10.1.0.2 and later
 [Note 421441.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=421441.1) - DataPump Import Via NETWORK_LINK Is Slow With CURSOR_SHARING=FORCE, **Affected Version:** 9.2.0.6 to 10.2.0.3
 [Note 416238.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=416238.1) - Impdp With NETWORK_LINK Runs Very Slowly at Estimate Stage,** Affected Version:** 10.2.0.1 to 11.2.0.4
 [Note 1488229.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1488229.1) - Performance Problems When Transferring LOBs Using IMPDP With NETWORK_LINK, **Affected Version:** 10.1.0.3 to 11.2.0.4
 [Note 1986328.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1986328.1) - DataPump Metadata Export (EXPDP) Is Slow, **Affected Version:** 11.2.0.3 to 12.1.0.2
  • TABLE_EXISTS_ACTION
 [Note 780784.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=780784.1) - Datapump Import (IMPDP) With TABLE_EXISTS_ACTION=TRUNCATE Is Slower When Table Exists, **Affected Version:** 10.2.0.1 and later
 [Note 952853.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=952853.1) - IMPDP Performs Extremely Slow When Importing In Parallel Into An Existing Partitioned Table, **Affected Version:** 10.2.0.4 to 11.2.0.1
  • PARALLEL>0 And CONTENT=METADATA_ONLY
  [Note 1467188.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=1467188.1) - Datapump Import With Both PARALLEL>0 And CONTENT=METADATA_ONLY Has Bad Performance, **Affected Version:** 11.2.0.3 and later
  • REMAP_SCHEMA
 [Note 812864.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=812864.1) - DataPump Import with REMAP_SCHEMA is Very Slow, **Affected Version:** 10.2.0.1 and later
 [Note 429846.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=429846.1) - Slow Data Pump with REMAP_SCHEMA and REMAP_TABLESPACE parameters, **Affected Version:** 10.2.0.1 to 10.2.0.3
  • REMAP_TABLESPACE
 [Note 429846.1](https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=1948188.1&id=429846.1) - Slow Data Pump with REMAP_SCHEMA and REMAP_TABLESPACE parameters, **Affected Version:** 10.2.0.1 to 10.2.0.3