转载：log file sync
log file sync 是由于事务提交太过于频繁，IO速度跟不上，从而出现这个等待。
1，提高LGWR的优先级
alter system set "_high_priority_processes"='LMS*|LGWR|PMON' scope=spfile;
Disclaimers:
1. This is a hidden parameter - so you probably shouldn’t use it.
2. Reducing commits is the best way to solve “log file sync” issues.
3. Isolating the lgwr process via processor affinity is another possible approach.
4. Sit up straight and don’t talk with your mouth full
2，设为批量提交commit_write=batch
3,通过exp/imp导出导入整理碎片。把log磁盘和data磁盘分开存放
阅读(3325) | 评论(0) | 转发(0) |
