昨天客户说DB在4点到5点查询以及登陆都很慢,我看了下AWR种的TOP 5事件,
Top 5 Timed Foreground EventsEvent Waits Time(s) Avg wait (ms) % DB time Wait Class
log file switch (checkpoint incomplete) 4,916 29,450 5991 54.46 Configuration
buffer busy waits 2,816 10,251 3640 18.96 Concurrency
log file sync 61,615 6,075 99 11.23 Commit
DB CPU 4,594 8.50
enq: KO - fast object checkpoint 213 1,491 6998 2.76 Application
我就加了3个日志文件组,并将文件组大小增大了5倍,可是今天情况还是和昨天一样,怎么解决啊?
Top 5 Timed Foreground EventsEvent Waits Time(s) Avg wait (ms) % DB time Wait Class
log file switch (checkpoint incomplete) 4,916 29,450 5991 54.46 Configuration
buffer busy waits 2,816 10,251 3640 18.96 Concurrency
log file sync 61,615 6,075 99 11.23 Commit
DB CPU 4,594 8.50
enq: KO - fast object checkpoint 213 1,491 6998 2.76 Application
我就加了3个日志文件组,并将文件组大小增大了5倍,可是今天情况还是和昨天一样,怎么解决啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货