一 问题描述
impdp导入3G的表结构文件,导入了一上午,还没导完,感觉不应该这么慢。
二 排查思路
2.1 查看导入日志
发现最新信息是Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
说明在创建索引
2.2 查看导入进度
显示在创建索引:
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: ESOP2TEST
Object Name: SYS_MSISDNNUMID
Object Type: SCHEMA_EXPORT/TABLE/INDEX/INDEX
Completed Objects: 33
Worker Parallelism: 1
2.3 查看该job在等待什么
select sid,sql_id,event from v$session where action='SYS_IMPORT_FULL_01';
SID SQL_ID EVENT
---------- ------------- ----------------------------------------------------------------
146 bjf05cwcj5s6p wait for unread message on broadcast channel
295 58rzgvcv6gnjs statement suspended, wait error to be cleared
2.4 查看告警日志是否有报错
发现有表空间不足相关的报错:
tatement in resumable session 'SYS.SYS_IMPORT_FULL_01.1' was suspended due to
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
三 解决办法
为该表空间扩容
--本篇文章参考了https://blog.51cto.com/hbxztc/1959357