日志异常,io,cpu检查

《日志异常,io,cpu检查》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、日志异常,IO,CPU的检查日志异常，IO,CPU的检查个人分类：oracle平台:SunOS5.8Generic_108528-23sun4usparcSUNW,Ultra-Enterprise数据库:8.1.5.0.0症状:响应缓慢，应用请求已经无法返回登陆数据库,发现redo日志组除current外都处于active状态oracle:/oracle/oracle8>sqlplus"/assysdba"SQL*Plus:Release8.1.5.0.0-ProductiononThuJun2318:56:062005(c)Copyright

2、1999OracleCorporation.Allrightsreserved.Connectedto:Oracle8iEnterpriseEditionRelease8.1.5.0.0-ProductionWiththePartitioningandJavaoptionsPL/SQLRelease8.1.5.0.0-ProductionSQL>select*fromv$log;GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIRST_TIM-------------------

3、------------------------------------------------------------------------11520403314572801NOACTIVE1.3861E+1023-JUN-0521520404314572801NOACTIVE1.3861E+1023-JUN-0531520405314572801NOACTIVE1.3861E+1023-JUN-0541520406314572801NOCURRENT1.3861E+1023-JUN-0551520398314572801NOACTIVE1

4、.3860E+1023-JUN-0561520399314572801NOACTIVE1.3860E+1023-JUN-05715204001048576001NOACTIVE1.3860E+1023-JUN-05815204011048576001NOACTIVE1.3860E+1023-JUN-05915204021048576001NOACTIVE1.3861E+1023-JUN-059rowsselected.SQL>/GROUP#THREAD#SEQUENCE#BYTESMEMBERSARCSTATUSFIRST_CHANGE#FIR

5、ST_TIM-------------------------------------------------------------------------------------------11520403314572801NOACTIVE1.3861E+1023-JUN-0521520404314572801NOACTIVE1.3861E+1023-JUN-0531520405314572801NOACTIVE1.3861E+1023-JUN-0541520406314572801NOCURRENT1.3861E+1023-JUN-055

6、1520398314572801NOACTIVE1.3860E+1023-JUN-0561520399314572801NOACTIVE1.3860E+1023-JUN-05715204001048576001NOACTIVE1.3860E+1023-JUN-05815204011048576001NOACTIVE1.3860E+1023-JUN-05915204021048576001NOACTIVE1.3861E+1023-JUN-059rowsselected.如果日志都处于active状态，那么显然DBWR的写已经无法跟上logswit

7、ch触发的检查点。接下来让我们检查一下DBWR的繁忙程度:SQL>!oracle:/oracle/oracle8>ps-ef

8、grepora_oracle227310Mar31?57:40ora_smon_hysms02oracle226610Mar31?811:42ora_dbw0_hysms02oracle2264116Mar31?16999:57ora_pmon_hysms02oracle226810Mar31?1649:07ora_lgwr_hysms02oracle227910Mar31?8:09ora_snp1_hysms02ora

9、cle228110Mar31?4:22ora_snp2_hysms02oracle228510Mar31?9:40ora_snp4_hysms02or