查找锁源方法:
1、查找出被锁的进程:
SQL>select * from gv$lock where lmode=0 and sid>9;
2、根据被锁进程的ID1 ID2查找出lmode不等于0的进程(即为锁源)
SQL>select * from gv$lock where id1=1114142 and id2=9205553;
找出lmode<>0的那条的SID号
3、根据lmode不等于0的那条sid查找session名称:
SQL>select * from gv$session where sid=92;
SQL>select * from gv$lock where id1=3604524 and id2=7292675;
SQL>select * from gv$session where sid=333
阅读(855) | 评论(0) | 转发(0) |
