4 Replies Latest reply: Feb 7, 2013 5:15 AM by asahide RSS

    IMPDP schema import is very slow in Exadata

    Midhun GT
      Hi,

      I'm performing a datapump import of around 30 schemas. The size of dump file is 23.86 GB. Database is Exadata 11.2.0.2.0
      $cat ODS_SHARED_DATA_IMP.par
      DIRECTORY=DATPRD_DPUMP
      LOGFILE=ODS_SHARED_DATA_IMP.log
      JOB_NAME=ODS_SHARED_DATA_IMP
      DUMPFILE=ODS_SHARED_DATA_EXP_%U.dmp
      CONTENT=DATA_ONLY
      PARALLEL=12
      TABLE_EXISTS_ACTION=APPEND
      But the import is running for 8hrs and still in first step of table_data.
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

      The worker session is running below query most of the time.
      SELECT SUM(DBMS_LOB.COMPARE(SPBND, DSPBND))
      FROM KU$_TEMP_SUBPARTDATA_VIEW
      WHERE OBJ_NUM = :B1
      What could be the reason for slow process. how can we improve the performance of this import. Please advise.

      Thanks and Regards,
      Midhun GT