oracle 死锁查询 解锁

死锁查询：

 

SELECT /*+ rule */

 s.username,

 decode(l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL,

 o.owner,

 o.object_name,

 o.object_type,

 s.sid,

 s.serial#,

 s.terminal,

 s.machine,

 s.program,

 s.osuser

  FROM v$session s, v$lock l, dba_objects o

 WHERE l.sid = s.sid

   AND l.id1 = o.object_id(+)

   AND s.username is NOT NULL

 

 

解锁：

 

杀死该session： 　　alter system kill session 'sid,serial#'

 

表快照：

 

select * from tablename As Of Timestamp to_Timestamp(timestr, 'yyyy-mm-dd hh24:mi:ss')