oracle数据泵导入卡住

1、数据泵导入一个一百多G的库，看上去卡在这里SCHEMA_EXPORT/TABLE/INDEX/INDEX

2、select * from DBA_DATAPUMP_JOBS;

查看数据泵导入任务详情SQL> select * from dba_datapump_jobs;OWNER_NAME                     JOB_NAME------------------------------ ------------------------------OPERATION------------------------------------------------------------JOB_MODE------------------------------------------------------------STATE                              DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS------------------------------ ---------- ----------------- -----------------GDGDCS                         SYS_IMPORT_FULL_01IMPORTFULLEXECUTING                               1                 1                 3

3、查看任务会话是否有异常信息

select sid,sql_id,event from v$session where action='SYS_IMPORT_FULL_01';

SQL> select sid,sql_id,event from v$session where action='SYS_IMPORT_FULL_01';       SID SQL_ID---------- -------------EVENT----------------------------------------------------------------       310db file scattered read       314wait for unread message on broadcast channel

4、wait for unread message on broadcast channel为正常空闲事件

5、查看alert日志，发现没有报错，判断此事件为假性卡顿，正常等待即可