以下SQL占用了大量的时间,也是受影响的SQL,buffer busy waits很高。
insert into mcc_asyn_pos ( suid, oemcode, commaddr, utc, dst, apc, lat, lon, head, speed, distance, tflag, vflag, ost, ostdesc ) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 )
TOP5的两个事件:
latch: cache buffers chains
buffer busy waits
备份和mcc_asyn_pos表的操作导致了latch: cache buffers chains,buffer busy waits等待事件。影响了备份和insert的性能。