1.查看数据库所有的锁表记录 SELECT S.SID SESSION_ID, S.USERNAME, LMODE, REQUEST, O.OWNER || '.' || O.OBJECT_NAME || ' (' || O.OBJECT_TYPE || ')', S.TYPE LOCK_TYPE, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2 FROM V$LOCK L, SYS.DBA_OBJECTS O, V$SESSION S WHERE L.SID = S.SID AND L.ID1 = O.OBJECT_ID; 2.查看当前用户下所有的锁表记录 SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine, s.terminal, s.logon_time, l.type FROM v$session s, v$lock l WHERE s.sid = l.sid AND s.username IS NOT NULL ORDER BY sid; 3.解锁 alter system kill session 'sid,SERIAL#';