系统警告说REDO LOG Writer经常时间长 经常200多ms
ORACLE: REDO LOG 系统警告说REDOLOGWriter经常时间长经常200多ms
SPOT LIGTH 给出警告。 Severity:High Reason:Average redo log write time is 118 ms (averaged over 30 seconds) RedoLogwriter(LGWR)
调整:
1、调整redo log buffer大小:512K *CPU个数或218* CPU个数(CPU_COUNT)
select * from v$version where rownum<2;
select * from v$sgainfo where name in ('Fixed SGA Size','Redo Buffers','Granule Size'); (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |