数据库出现 enq: TX - row lock contention
今天上午过来,做awr报告数据库出现了很多enq: TX - row lock contention的等待事件,以前从来没有过的,感觉很奇怪。查询gv$session中的等待事件
在结果没有出现该等待事件,我们去ash中在看看
今天上午过来,做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#
------------------------------ ---------- ---------- ------------- ---------------------------------------------------------------