SELECT SESS.SID,
SESS.SERIAL#,
LO.ORACLE_USERNAME,
LO.OS_USER_NAME,
LO.LOCKED_MODE,
AO.OBJECT_NAME
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 'sid,serial#'; ----解锁