impdp stuck on index import

impdp import is stuck on:


Processing object type
SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

How can you debug this?

During the impdp process, it doesn't import indexes, in fact it runs number of CREATE INDEX statements.

There could be various reasons of slow index creations such as inefficient PGA memory allocation and IO performance of underlying storage. Parallel(depending on available server resources-CPU,IO) option could improve performance of index-creation.


How can you debug this?

• You can use the following query to check the status of the job.

select * from dba_datapump_jobs;

• Join dba_datapump_sessions with v$session_wait to know whether the impdp session is waiting for some resources.

• Check alert log for possible error/warning messages.

StackExchange Database Administrators Q#172388, answer score: 4