先查那些被锁了
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;
杀掉需要解锁的
alter system kill session 'SESSION_ID,SERIAL#';
先查那些被锁了
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;
杀掉需要解锁的
alter system kill session 'SESSION_ID,SERIAL#';