Thanks Jhonatan, Even when the import is hanged several hours, I didn't find a specific wait event, or I'm querying the wrong t able. select * from V$SESSION_WAIT order by seconds_in_wait desc 10 325 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 17101 WAITING 19 325 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 17101 WAITING 14 325 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 17101 WAITING 11 34903 SQL*Net message from dblink driver id 675562835 28444553 #bytes 1 00000001 0 00 0 17097 WAITING 26 25 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 11791 WAITING 30 18 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 11769 WAITING 27 18 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 11769 WAITING 25 18 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 11652 WAITING 21 16 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 7041 WAITING 20 725 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 7015 WAITING 6 19 rdbms ipc message timeout 180000 0002BF20 0 00 0 00 0 544 WAITING 9 3228 rdbms ipc message timeout 30000 00007530 0 00 0 00 0 294 WAITING 5 280 smon timer sleep time 300 0000012C failed 0 00 0 00 0 270 WAITING 22 350 SQL*Net message from client driver id 1.414E+09 54435000 #bytes 1 00000001 0 00 0 185 WAITING 8 5666 rdbms ipc message timeout 6000 00001770 0 00 0 00 0 43 WAITING 18 70 null event 1.414E+09 54435000 1 00000001 0 00 -1 0 WAITED KNOWN TIME 7 4194 rdbms ipc message timeout 500 000001F4 0 00 0 00 0 0 WAITING 31 4180 library cache lock handle address 291879320 1165B998 lock address 296691392 11AF26C0 100*mode+namespace 201 000000C9 0 0 WAITING 16 6090 library cache lock handle address 291879320 1165B998 lock address 296769524 11B057F4 100*mode+namespace 201 000000C9 0 0 WAITING 4 14294 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 0 WAITING 1 7118 pmon timer duration 300 0000012C 0 00 0 00 0 0 WAITING 2 16303 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 0 WAITING 3 7592 rdbms ipc message timeout 300 0000012C 0 00 0 00 0 0 WAITING -- //www.freelists.org/webpage/oracle-l