一次大量enq:TX - row lock contention锁等待的问题(一)

今天下午接到业务报障，系统出现问题，可能是 数据库的问题

1，登录系统,查看等待事件，大量row lock

[sql]

6:12:58]

[16:12:58] SID SERIAL# OSUSER USERNAME SVRPROC SQL_HASH_VALUE EVENT P1 P2 P3

[16:12:58]------ ---------- -------- -------- ------------------------ -------------- ------------------------------ --------------------- ---------- ----------

[16:12:58] 245 4637 app SOi 41353726 3961605653 db file sequential read 226 253846 1

[16:12:58] 3645 58373 app SOi 61604288 1523472697 db file sequential read 178 3443786 1

[16:12:58] 5651 26047 app PAR 64291328 2455471834 db file sequential read 142 2712414 1

[16:12:58] 13207 5781 app SOi 62915316 3349830783 db file sequential read 211 1462130 1

[16:12:58] 10198 64603 app PAR 45679292 2510471152 db file sequential read 91 2141228 1

[16:12:58] 11528 8197 app PAR 51708698 2284416154 db file sequential read 126 1683178 1

[16:12:58] 8863 53455 baoyb AIM 16319376 1467486395 db file sequential read 115 2078933 1

[16:12:58] 1 59191 app SOi 46072062 2644787661 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 22 26111 app SOi 48694114 3874015681 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 39 38595 AIC SOi 7210748 208342339 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 62 56753 AIC SOi 29426814 1088173244 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58]

[16:12:58] SID SERIAL# OSUSER USERNAME SVRPROC SQL_HASH_VALUE EVENT P1 P2 P3

[16:12:58]------ ---------- -------- -------- ------------------------ -------------- ------------------------------ --------------------- ---------- ----------

[16:12:58] 66 42397 app SOi 48366550 1088173244 enq: TX - row lock contention 1415053318 32047109 25967

[16:12:58] 189 52823 AIC SOi 38404948 208342339 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 212 451 app SOi 42402934 673329617 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 232 55865 app SOi 21956094 673329617 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 240 701 AIC SOi 42991652 208342339 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 247 6333 app SOi 5375522 3538716681 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 388 17499 app SOi 42140914 1763411819 enq: TX - row lock contention 1415053318 21889041 50009

[16:12:58] 389 50591 app SOi 33292644 208342339 enq: TX - row lock contention

www.2cto.com

2，使用锁等待的脚本查看，holder比较多，难以判断根源的holder

[sql]

[16:16:03]SESS ID1 ID2 LMODE REQ