oracle查看锁表信息以及解锁
查看锁表信息:
selecta.object_name,b.session_id,c.serial#,c.program,c.username,c.command,c.machine,c.lockwait
fromall_objects a,v$locked_object b,v$session cwherea.object_id=b.object_idandc.sid=b.session_id;
解锁:
altersystem kill session'session_id,seri...
原创
2020-09-27 14:44:35 ·
186 阅读 ·
0 评论