求一查询oracle数据库死锁的SQL语句

求一查询oracle数据库死锁的SQL语句
谢谢

---

摆渡一下，啥都有了。。。
select C.sid,C.serial#,B.object_name,C.username,C.machine,C.terminal,C.program
from v$locked_object A,all_objects B,v$session C
where A.session_id = C.sid and A.object_id = B.object_id;

---

select object_id,session_id,locked_mode from v$locked_object;
 
  select t2.username,t2.sid,t2.serial#,t2.logon_time 
  from v$locked_object t1,v$session t2 
  where t1.session_id=t2.sid order by t2.logon_time;

---

好像要管理员权限才可以用上面的SQL

---

select object_id,session_id,locked_mode from v$locked_object;
 
  select t2.username,t2.sid,t2.serial#,t2.logon_time 
  from v$locked_object t1,v$session t2 
  where t1.session_id=t2.sid order by t2.logon_time;

---

引用

摆渡一下，啥都有了。。。
select C.sid,C.serial#,B.object_name,C.username,C.machine,C.terminal,C.program
from v$locked_object A,all_objects B,v$session C
where A.session_id = C.sid and A.object_id = B.object_id;

这条语句我验证了，对于阻塞的情况不能排除。

---

SQL code:

1、先查询出来
select b.sid,b.machine,c.object_name,a.oracle_username,
a.locked_mode,b.osuser,
'alter system kill