查看锁表逻辑
SELECT L.SESSION_ID SID,
S.SERIAL#,
L.LOCKED_MODE AS 锁模式,
L.ORACLE_USERNAME AS 登录用户,
L.OS_USER_NAME AS 登录机器用户名,
S.MACHINE AS 机器名,
S.TERMINAL AS 终端用户名,
O.OBJECT_NAME AS 被锁对象名,
S.LOGON_TIME AS 登录数据库时间
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#;
解锁逻辑
解锁查询字段中'sid,serial'
ALTER SYSTEM KILL SESSION 'sid,SERIAL#';
注意
解锁需要有相关权限的用户才可以操作,请勿自己随意解锁!!!