oracle 锁表查询 进程清除

SELECT SESS.SID, SESS.SERIAL#, MACHINE, LO.ORACLE_USERNAME, AO.OBJECT_NAME, LO.LOCKED_MODE
FROM v$locked_object LO,  dba_objects AO,  v$session SESS
WHERE AO.OBJECT_ID = LO.OBJECT_ID
	AND LO.SESSION_ID = SESS.SID;

清除进程

ALTER SYSTEM KILL SESSION '482,63990';