oracle死锁进程查看以及删除
最近又遇到oracle死锁问题,先记录一下
查看锁表进程:
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name,
ao.object_name,
lo.locked_mode,
sess.LOGON_TIME,
sess.machine
from vlockedobjectlo,dbaobjectsao,vlocked_object lo,
dba_objects ao,
vlockedobjectlo,db
原创
2021-01-22 10:44:48 ·
244 阅读 ·
0 评论