Hello,

In v$Session_Wait following info was seen for Import session which hangs...

Event: SQL*Net more data from client
Wait_Class: Network
Seconds_IN_Wait: 1900

Please let us know if this gives some clue to solve this issue.

Thanks & Regards,

Shailesh