session 等待enq: TX - row lock contention

RAC环境:


查看行争用的等待session

select inst_id,sid,seconds_in_wait from gv$session_wait where wait_class <>'Idle' and event='enq: TX - row lock contention'


查看阻塞与被阻塞的session

select inst_id,sid,taddr,lockwait,status,schemaname,sql_id,prev_sql_id,blocking_instance,blocking_session,seconds_in_wait from gv$session where (sid=1231 and inst_id=5) or (sid=821 and inst_id=3) or (sid=1011 and inst_id=4)


查看等待请求lock类型

select * from v$lock where kaddr='000000053CA10910'


查看enq: TX - row lock contention相关sql

select * from table(dbms_xplan.display_awr('bunvx480ynf57'));

select * from gv$sql where sql_id='6yhtsctmu6st0'
select m.sql_fulltext,n.value_string from v$sql m,v$sql_bind_capture n where m.sql_id='6yhtsctmu6st0' and m.child_address=n.child_address;
阅读更多
个人分类: Oracle
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭