oracle数据库表锁,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#';