5和6 objbc oracle_【案例】gc buffer busy acquire与enq:TX–index contention的争用

【案例】gc buffer busy acquire与enq:TX–index contention的争用

时间:2016-11-06 19:04   来源:Oracle研究中心   作者:HTZ   点击:

次

天萃荷净

Oracle研究中心案例分析：运维DBA反映某个系统就出现大量的gc buffer busy acquire与enq:TX – index contention的争用。

1，查看会话等待信息

SQL> @we.sql

SESS_SERIAL               STATUS                            BLOCK_SESS      RUN   ROW_WAIT

I EVENT               OSPID                     STATE      COM SQL_ID             INST:SESS       TIME  FILE#:OBJ#:BLOCK#:ROW#

-- ------------------  ------------------------- ---------- --- ------------------ --------------- ----- ----------------------

1 gc buffer busy acq  2156:5297:27140           A.W.232MS  INS C.9zt41cpy5gkf8:0  F.1.1016        2055  86813:170:2925296:0

gc buffer busy acq  2274:22651:18637          A.W.323MS  INS C.9zt41cpy5gkf8:0  F.1.1016        644   86813:170:2925296:0

gc buffer busy acq  2279:3411:12231           A.W.219MS  INS C.9zt41cpy5gkf8:0  F.1.1016        1710  86813:170:2925296:0

gc buffer busy acq  2280:2077:19130           A.W.435MS  INS C.9zt41cpy5gkf8:0  F.1.1016        475   86813:170:2925296:0

gc buffer busy acq  2282:43097:12289          A.W.260MS  INS C.9zt41cpy5gkf8:0  F.1.1016        1708  86813:170:2925296:0

gc buffer busy acq  2285:50617:17985          A.W.936MS  INS C.9zt41cpy5gkf8:0  F.1.1016        798   86813:170:2925296:0

gc buffer busy acq  2286:22723:19032          A.W.621MS  INS C.9zt41cpy5gkf8:0  F.1.1016        492   86813:170:2925296:0

gc buffer busy acq  2289:17463:27186          A.W.216MS  INS C.9zt41cpy5gkf8:0  F.1.1016        2074  86813:170:2925296:0

gc buffer busy acq  2293:4003:21780           A.W.232MS  INS C.9zt41cpy5gkf8:0  F.1.1016        2065  86813:170:2925296:0

gc buffer busy acq  2295:26043:12181          A.W.216MS  INS C.9zt41cpy5gkf8:0  F.1.1016        1708  86813:170:2925296:0

gc buffer busy acq  2420:279:21801            A.W.223MS  INS C.9zt41cpy5gkf8:0  F.1.1016        2065  86813:170:2925296:0

gc buffer busy acq  2422:511:27258            A.W.228MS  INS C.9zt41cpy5gkf8:0  F.1.1016        2074  86813:170:2925296:0

gc buffer busy acq  2423:57659:17947          A.W.417MS  INS C.9zt41cpy5gkf8:0  F.1.1016        803   86813:170:2925296:0

gc buffer busy acq  2426:56567:12077          A.W.231MS  INS C.9zt41cpy5gkf8:0  F.1.1016        1711  86813:170:2925296:0

gc buffer busy acq  2428:28099:19132          A.W.374MS  INS C.9zt41cpy5gkf8:0  F.1.1016        469   86813:170:2925296:0

gc buffer busy acq  2429:56481:12183          A.W.250MS  INS C.9zt41cpy5gkf8:0  F.1.1016        1710  86813:170:2925296:0

gc buffer busy acq  2432:1795:21782           A.W.214MS  INS C.9zt41cpy5gkf8:0  F.1.