oracle数据库锁表

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#';