数据库出现 enq: TX - row lock contention

数据库出现 enq: TX - row lock contention

今天上午过来，做awr报告数据库出现了很多enq: TX - row lock contention的等待事件，以前从来没有过的，感觉很奇怪。查询gv$session中的等待事件

scrac1/sys@JSCN> select event,count(*) from gv$session group by event;

EVENT                                                              COUNT(*)
---------------------------------------------------------------- ----------
SQL*Net message from client                                             275
Streams AQ: waiting for messages in the queue                             2
ASM background timer                                                      2
wait for unread message on broadcast channel                              1
gcs remote message                                                       12
ges remote message                                                        2
jobq slave wait                                                           3
rdbms ipc message                                                        34
smon timer                                                                2
pmon timer                                                                2
Streams AQ: qmn slave idle wait                                           3
class slave wait                                                          2
PX Deq: reap credit                                                       2
PX Deq: Execution Msg                                                     1
Streams AQ: waiting for time management or cleanup tasks                  2
Streams AQ: qmn coordinator idle wait                                     2
DIAG idle wait                                                            2

17 rows selected.

在结果没有出现该等待事件，我们去ash中在看看

scrac1/sys@JSCN> select SAMPLE_TIME,SESSION_ID,USER_ID,SQL_ID,EVENT,CURRENT_OBJ#,CURRENT_FILE#,CURRENT_BLOCK#  from GV_$ACTIVE_SESSION_HISTORY
where event like 'enq: TX%' and  module='JDBC Thin Client' and rownum<=10;    2

SAMPLE_TIME                    SESSION_ID    USER_ID SQL_ID        EVENT                                                            CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#
------------------------------ ---------- ---------- ------------- ---------------------------------------------------------------