关闭

session 等待enq: TX - row lock contention

524人阅读 评论(0) 收藏 举报
分类:

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;
0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:124913次
    • 积分:2273
    • 等级:
    • 排名:第17187名
    • 原创:103篇
    • 转载:58篇
    • 译文:0篇
    • 评论:2条
    文章分类