Oracle 11.2.0.4 impdp every slow on step "Object Type: SCHEMA_EXPORT/VIEW/COMMENT"
Hi,
I am import data into 11.2.0.4 RAC database using impdp. dump file size is around 13GB. Tables loading and index rebuild are fast.
But it is very slow on step "Processing object type SCHEMA_EXPORT/VIEW/COMMENT"
Import> status
Job: SYS_IMPORT_FULL_01
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 13,628,484,152
Percent Done: 99
Current Parallelism: 3
Job Error Count: 0
Dump File: /u40/oracle/backup/dev1129/expdp_ifsprd2_01.dump
Dump File: /u40/oracle/backup/dev1129/expdp_ifsprd2_02.dump
Dump File: /u40/oracle/backup/dev1129/expdp_ifsprd2_03.dump
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Type: SCHEMA_EXPORT/VIEW/COMMENT
Completed Objects: 29,280