oracle查看死链接 并kill掉

-------------------------------

SELECT
	A .*, b.*
FROM
	v$locked_object A,
	dba_objects b
WHERE
	b.object_id = A .object_id
	
-------------------------------
SELECT
	t2.username,
	t2. SID,
	t2.serial#,
	t2.logon_time
FROM
	v$locked_object t1,
	v$session t2
WHERE
	t1.session_id = t2. SID
ORDER BY
	t2.logon_time
-----------------------------
ALTER SYSTEM KILL SESSION 'ID,Serial#'
-----------------------------

--------------------------

-------------------------------------------