Oracle 锁表的查看 可解锁

Oracle 中被锁死表的查看语句

记录sid和 ssid两个Id

 SELECT  l.session_id sid, --解锁SID 参数1 s.serial# as ssid, --解锁SSID 参数2  l.locked_mode,  l.oracle_username,　　l.os_user_name,   s.machine,    s.terminal,    o.object_name,    s.logon_time　　FROM v$locked_object l, all_objects o, v$session s　　WHERE l.object_id = o.object_id　　AND l.session_id = s.sid　　ORDER BY sid, s.serial# ;解锁语句
ALTER system KILL session '参数1,参数2';