Data Import using IMPDP is deadly slow.
I am trying to import data using impdp utility, Presently it is trying to create a domain index from more than 8 Hrs and status it is still showing as executing.
Is there any way I can diagnose wheter it is hang or it is still doing something.
Import> STATUS
Job: SYS_IMPORT_SCHEMA_01
Operation: IMPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 61,879,358,544
Percent Done: 99
Current Parallelism: 1
Job Error Count: 0
Dump File: /data/impdp_osxx/OSXX_1.dmp
Dump File: /data/impdp_osxx/OSXX_2.dmp
Dump File: /data/impdp_osxx/OSXX_3.dmp
Worker 1 Status:
State: EXECUTING
Object Schema: OSXX
Object Name: A44_IX1