系统警告说REDO LOG Writer经常时间长 经常200多ms怎么调整？Redo Log writer (LGWR)
The Redo log writer writes the redo buffer blocks from SGA to redo log files on the hard disk.An alarm can become current on this process if log switch waits occur (Log Switch Time alarm), or if the average redo I/O time exceeds a threshold (Average Time to Sync a Redo Log Entry alarm).
The Redo log writer writes the redo buffer blocks from SGA to redo log files on the hard disk.An alarm can become current on this process if log switch waits occur (Log Switch Time alarm), or if the average redo I/O time exceeds a threshold (Average Time to Sync a Redo Log Entry alarm).
1、调整redo log buffer大小：512K *CPU个数或218* CPU个数（CPU_COUNT）
2、调优log buffer
2.看下你的在线日子文件多大