问题:今天用impdp导入,导入很慢,hang住了。等了5分钟还是没有正常的日志打印出来。
怎么办?
hang住怎么办?
1.首先把当前时段的active_session 找出来。就知道当前session 到底在干嘛,到底在等待事件是什么
statement suspended, wait error to be cleared
2.查看alert_newpay1.log,就可以看到一条错误日志
DM00 started with pid=25, OS id=27517, job SYSTEM.SYS_IMPORT_SCHEMA_03
Thu Sep 17 11:36:42 2015
DW00 started with pid=26, OS id=27519, wid=1, job SYSTEM.SYS_IMPORT_SCHEMA_03
statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_03.1' was suspended due to
ORA-01653: unable to extend table SYSTEM.SYS_IMPORT_SCHEMA_03 by 8 in tablespace SYSTEM
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table SYSTEM.SYS_IMPORT_SCHEMA_03 by 8 in tablespace SYSTEM
3.用oerr 查看一下ora-39171错误,就知道,大概定位表空间的问题。
4.最终问题解决:因为表空间system满了,不能自动扩展。加文件即可。
怎么办?
hang住怎么办?
1.首先把当前时段的active_session 找出来。就知道当前session 到底在干嘛,到底在等待事件是什么
statement suspended, wait error to be cleared
2.查看alert_newpay1.log,就可以看到一条错误日志
DM00 started with pid=25, OS id=27517, job SYSTEM.SYS_IMPORT_SCHEMA_03
Thu Sep 17 11:36:42 2015
DW00 started with pid=26, OS id=27519, wid=1, job SYSTEM.SYS_IMPORT_SCHEMA_03
statement in resumable session 'SYSTEM.SYS_IMPORT_SCHEMA_03.1' was suspended due to
ORA-01653: unable to extend table SYSTEM.SYS_IMPORT_SCHEMA_03 by 8 in tablespace SYSTEM
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table SYSTEM.SYS_IMPORT_SCHEMA_03 by 8 in tablespace SYSTEM
3.用oerr 查看一下ora-39171错误,就知道,大概定位表空间的问题。
4.最终问题解决:因为表空间system满了,不能自动扩展。加文件即可。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30393770/viewspace-1802272/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30393770/viewspace-1802272/