ORACLE解锁:
SELECT OBJECT_ID,SESSION_ID,SERIAL#,
ORACLE_USERNAME,OS_USER_NAME,S.PROCESS
FROM V$LOCKED_OBJECT A,
V$SESSION S WHERE A.SESSION_ID=S.SID
查出被lock 的对象
然后 alter system kill session 'sid,serial#';
2022-01-08 00:49:03
ORACLE解锁:
SELECT OBJECT_ID,SESSION_ID,SERIAL#,
ORACLE_USERNAME,OS_USER_NAME,S.PROCESS
FROM V$LOCKED_OBJECT A,
V$SESSION S WHERE A.SESSION_ID=S.SID
查出被lock 的对象
然后 alter system kill session 'sid,serial#';
下一篇:struts2注解(转)