AWR报告，很多索引的行级锁冲突。

killkill_shadow · 发表于 2010-8-20 19:55

好帖留名，社保、卡中心那些系统的表和字段都是有规定，貌似 LAAC001 是身份证还是姓名什么的，一开始我看到这种数据库也头大。

yellowlee · 发表于 2010-9-18 20:24

原帖由 lsq_008 于 2010-6-22 16:15 发表
Top 5 Timed Events                                        Avg %Total
~~~~~~~~~~~~~~~~~~                                     wait Call
Event                               Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
enq: TX - index contention       100,662    192,189 1909 56.0 Concurrenc
enq: US - contention             172,842    64,292 372 18.7    Other
latch: row cache objects          827,074    38,649    47 11.3 Concurrenc
db file sequential read          2,213,102    18,923    9 5.5 User I/O
CPU time                                        14,680          4.3

Segments by Row Lock Waits          DB/Inst: xxxx/xxxx  Snaps: 16921-16922
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot

                                                                  Row
         Tablespace                   Subobject  Obj.       Lock % of
Owner       Name Object Name          Name    Type       Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
xxxxx    xxxxxxxxxx xxxxxxxxxxxxx          INDEX    14,726 38.69
xxxxx    xxxxxxxxxx xxxxxxxxxxxxx          INDEX       5,271 13.85
xxxxx    xxxxxxxxxx xxxxxxxxxxxxx          INDEX       3,949 10.38
xxxxx    xxxxxxxxxx xxxxxxxxxxxxx          INDEX       3,736 9.82
xxxxx    xxxxxxxxxx xxxxxxxxxxxxx          INDEX       3,349 8.80

这可能是索引块分裂引起的锁等待。