ITPub博客

首页 > 数据库 > Oracle > Solaris+Oracle 11g WARNING: aiowait timed out 1 times

Solaris+Oracle 11g WARNING: aiowait timed out 1 times

原创 Oracle 作者:yingzimizhan 时间:2016-04-14 08:59:07 0 删除 编辑
最近给数据库做巡检的时候,总会发现WARNING: aiowait timed out 1 times报错,如下alert的内容:

Thread 1 cannot allocate new log, sequence 52198
Private strand flush not complete
  Current log# 5 seq# 52197 mem# 0: /oradb/ADC/sysfile/redo05.log
Thread 1 advanced to log sequence 52198 (LGWR switch)
  Current log# 6 seq# 52198 mem# 0: /oradb/ADC/sysfile/redo06.log
Thu Apr 14 05:01:29 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:02:03 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:02:45 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:03:16 2016
minact-scn: useg scan erroring out with error e:12751
Thu Apr 14 05:03:35 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:05:16 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:07:34 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:07:34 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:07:34 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:07:34 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:07:34 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:07:35 2016
WARNING: aiowait timed out 1 times
Thu Apr 14 05:10:16 2016
Thread 1 cannot allocate new log, sequence 52199


是数据仓库系统,该段时间正在跑批处理程序,我怀疑是Solaris异步IO的问题,正在和厂商沟通,目前还没反馈。
--20160401
更改了disk_asynch_io,由true改为false,不报错了,但ETL特别慢;又改回为true;
--20160414
更改了db_writer_processes,由20改为28,今晚观察效果;

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26129555/viewspace-2080919/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-08-03

  • 博文量
    36
  • 访问量
    123812