问题 set line 120
select SQL_ID,event,count(*) from gv$session where wait_class <> Idle group by event,SQL_ID order by count(*);排查思路 oracle等待事件之free buffer waits Free buffer waits 等待事件总结 free buffer waits
尝试解决方案
修改db_writer…
os: centos 7.6 db: oracle 19.3
使用 swingbench 做的10G数据量压测,然后查看 AWR 报表时,分析一下 Top 10 Foreground Events by Total Wait Time. buffer busy waits 10.3.2 buffer busy waits
This wait indicates that there are some buffers in the buffer cache that…