问题：今天用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博客 ” ，链接：https://blog.itpub.net/30393770/viewspace-1802272/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- sysbench fileio 压测磁盘raid 5 raid 1 raid10 raid 50 情况
- oracle orion 压测磁盘性能raid10 raid5 raid50 数据
- tpcc-mysql 压测报告
- mysql benchmarksql 压测
- mysql ,tidb sysbench 测试结果记录
- pt-online-schema-change 错误集 Wide character
- mysql lock 大量会话锁住，快速定位，快速解锁
- tidb Error: Operation aborted by user answer '' (cliutil.operation_aborted)
- Oracle的OEM enterprise manager mail notificatio 邮件告警通知设置
- redis cluster 集群故障恢复操作思路
