求一查询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; 这条语句我验证了,对于阻塞的情况不能排除。 SQL code:
1、先查询出来 select b.sid,b.machine,c.object_name,a.oracle_username, a.locked_mode,b.osuser, 'alter system kill
下个Oracle for vista 版本的安装试试 10G和11G的 http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......