ORACLE技术论坛–请到ask.orasos.com提问

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
impd导入很智能---statement suspended, wait error to be cleared
2015 年 10 月 17 日
00:41
惜分飞
Admin
Forum Posts: 342
Member Since:
2010 年 07 月 31 日
Online

检查数据库,发现导入进程hang住不再干活

 

查询等待事件发现

SQL> select event from v$session where wait_class#<>6;

EVENT
—————————————————————-
SQL*Net message to client
statement suspended, wait error to be cleared

 

查看alert日志发现

Thread 1 advanced to log sequence 44 (LGWR switch)
  Current log# 4 seq# 44 mem# 0: /Data/oracle/oradata/commentdb/redo04.log
Sat Oct 17 00:32:23 2015
statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_01.1' was suspended due to
    ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2

 

增加temp文件后

SQL> alter tablespace temp2 add tempfile '/Data/oracle/oradata/commentdb/temp03.dbf' size 1G autoextend on next 128M maxsize 30G;

Tablespace altered.

等待事件正常了

SQL> select event from v$session where wait_class#<>6;

EVENT
—————————————————————-
SQL*Net message to client
direct path read temp
Data file init write

 

impdp也开始干活了

 

 

imdp是否干活,最简单区分方法,就是top 结合等待事件

Q Q:107644445  

Tel:13429648788

个人Blog(惜分飞)

提供专业ORACLE技术支持(数据恢复,安装实施,升级迁移,备份容灾,故障诊断,系统优化等)

    

       
   

评论功能已关闭。