oracle数据泵导入卡住

2025-10-26 04:39:24

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

声明：本网站引用、摘录或转载内容仅供网站访问者交流或参考，不代表本站立场，如存在版权或非法内容，请联系站长删除，联系邮箱：site.kefu@qq.com。