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日志，发现没有报错，判断此事件为假性卡顿，正常等待即可