3 Replies Latest reply on Jul 31, 2020 2:15 PM by Dean Gagne-Oracle

    Full Transportable Export/Import Slow

    user12136582

      Hi,

       

      I'm performing an upgrade from 11.2.0.4 (RHEL 6) to 19c on a different database server (RHEL 7).

       

      I am following the guidance as set out in the Oracle Whitepaper "Upgrade and Migrate to Oracle Database 19c" (https://www.oracle.com/au/a/tech/docs/twp-upgrade-oracle-database-19c.pdf) which recommends using the "Full Transportable Export/Import" method.

      However, I am finding the impdp part taking an extremely long time (days instead of hours). The size of the tablespaces is relatively small (5 GB over 4 tablespaces with around 2000 tables in total).

       

      My expdp parameter file looks like this:

       

      FULL=y

      TRANSPORTABLE=always

      VERSION=12

      DIRECTORY=DATA_PUMP_DIR

      DUMPFILE=export_to_19c.dmp

      METRICS=y

      EXCLUDE=statistics

      LOGFILE=export_to_19c.log

       

      My impdp parameter file looks like this:

       

      DIRECTORY=IMPORT_DIR

      DUMPFILE=export_to_19c.dmp

      METRICS=y

      LOGFILE=import_to_19c.log

      TRANSPORT_DATAFILES='/u02/app/oracle/oradata/TESTDB/users01.dbf', '/u02/app/oracle/oradata/TESTDB/customer.dbf', '/u02/app/oracle/oradata/TESTDB/other.dbf'

       

      The impdp takes alot of time (days) at this step:

       

      "W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE"

       

      I also noticed that the process ora_dw00 is reaching 100% CPU for the single core it's allocated.

       

      When I atttach to the SYS_IMPORT_TRANSPORTABLE_01 job I can see it's processing tables in one of my user defined schemas, but it's incredibly slow!

       

      Any help is much appreciated!