oracle导入停在SCHEMA_EXPORT/TABLE/INDEX/INDEX
工具/原料
oracle10g
windows命令行
方法/步骤
1、数据泵导入一个一百多G的库,看上去卡在这里SCHEMA_EXPORT/TABLE/INDEX/INDEX
2、select*fromDBA_DATAP曷决仙喁UMP_JOBS;查看数据泵导入任务详情SQL>select*fromdba_datapump_jobs;OWNER_绿覆冗猩NAMEJOB_NAME------------------------------------------------------------OPERATION------------------------------------------------------------JOB_MODE------------------------------------------------------------STATEDEGREEATTACHED_SESSIONSDATAPUMP_SESSIONS--------------------------------------------------------------------------GDGDCSSYS_IMPORT_FULL_01IMPORTFULLEXECUTING113
3、查看任务会话鋈守踬痊是否有异常信息selectsid,sql_id,eventfromv$sessionwhereaction='SYS_IMPORT_FULL_01';SQL>惺绅寨瞀selectsid,sql_id,eventfromv$sessionwhereaction='SYS_IMPORT_FULL_01';SIDSQL_ID-----------------------EVENT----------------------------------------------------------------310dbfilescatteredread314waitforunreadmessageonbroadcastchannel
4、waitforunreadmessageonbroadcastchannel为正常空闲事件
5、查看alert日志,发现没有报错,判断此事件为假性卡顿,正常等待即可