关于数据库:Oracle锁表解决

查问锁表记录

select object_name,       l.oracle_username,       machine,       s.sid,       s.serial#,       l.locked_mode,       lo.ctime,       lo.block,       lo.typefrom v$locked_object l,     dba_objects o,     v$session s,     v$lock lowhere l.object_id = o.object_id  and l.session_id = s.sid  and s.sid = lo.sid;

查问锁表语句

SELECT A.USERNAME,       A.MACHINE,       A.PROGRAM,       A.SID,       A.SERIAL#,       A.STATUS,       C.PIECE,       C.SQL_TEXT,       lo.lmode,       lo.ctime,       lo.block,       lo.type,       l.locked_modeFROM V$SESSION A,     V$SQLTEXT C,     v$lock lo,     v$locked_object lWHERE A.SID IN (SELECT DISTINCT T2.SID                FROM V$LOCKED_OBJECT T1,                     V$SESSION T2                WHERE T1.SESSION_ID = T2.SID)  AND A.SQL_ADDRESS = C.ADDRESS (+)  and A.sid = lo.sid  and A.sid = l.session_idORDER BY C.PIECE;

kill会话

alter system kill session 'SID, SERIAL';