===================================================================================================================
--查看锁表:
SELECT O.OWNER, O.OBJECT_NAME, O.OBJECT_TYPE, S.SID, S.SERIAL#
FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S
WHERE L.OBJECT_ID = O.OBJECT_ID
AND L.SESSION_ID = S.SID
ORDER BY O.OBJECT_ID, XIDUSN DESC;
--解锁
alter system kill session '372,20909';
--查死锁 可以查出来哪个库的哪个表锁了--
select s.sid,
s.serial#,
s.LOGON_TIME,
s.MACHINE,
s.TERMINAL,
l.oracle_username,
l.os_user_name,
a.object_name,--被锁的表名
l.locked_mode
from v$locked_object l, dba_objects a, v$session s
where a.object_id = l.object_id
&nb