Oracle 中被鎖死表的查看語句

記錄sid和 ssid兩個(gè)Id

 SELECT  l.session_id sid, --解鎖SID 參數(shù)1 s.serial# as ssid, --解鎖SSID 參數(shù)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 '參數(shù)1,參數(shù)2';