--查看锁表SESSION
SELECT DB.OWNER,
SESS.USERNAME,
DB.OBJECT_NAME,
DB.OBJECT_TYPE,
SESS.SID,
SESS.SERIAL#,
SESS.MACHINE,
SESS.PROGRAM,
SESS.LOGON_TIME,
SESS.SERVICE_NAME
FROM V$LOCKED_OBJECT LOC --锁对象表
JOIN V$SESSION SESS --SESSION表
ON LOC.SESSION_ID = SESS.SID
JOIN DBA_OBJECTS DB --所有对象
ON LOC.OBJECT_ID = DB.OBJECT_ID;
--结束SESSION进程
ALTER SYSTEM KILL SESSION 'SID,SERIAL#';