Skip to content
SRE运维进阶之路SRE运维进阶之路
github icon

    author iconClaycalendar icon2021年5月11日timer icon小于 1 分钟

    此页内容
    • 查看哪些表被锁住了
    • 查询引起死锁的会话
    • 查出sid和serial#
    • 查v$process视图,得到spid
    • 杀死进程(sid,serial#)

    # 查看哪些表被锁住了

    select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.OBJECT_ID;
    
    1

    # 查询引起死锁的会话

    select b.username,b.sid,b.serial#,logon_time from v$locked_object a , v$session b where a.session_id = b.sid order by b.LOGON_TIME;
    
    1

    # 查出sid和serial#

    select sid,serial#,paddr from v$session where sid = 259;
    
    1

    # 查v$process视图,得到spid

    select spid from v$process where addr= '00000003E32BDE28';
    
    1

    # 杀死进程(sid,serial#)

    alter system kill session '259,37152';
    
    1
    edit icon编辑此页open in new window
    上次编辑于: 2021/5/11 03:54:51
    贡献者: clay-wangzhi
    备案号:冀ICP备2021007336号
    Copyright © 2023 Clay