通过v$locked_object视图可以初步判断可疑锁定。或者用dba_outstanding_alterts视图(这个好像10g才有)
select object_name,object_type,reason,instance_name from dba_outstanding_alerts;
select sid,serial#,sql_id from v$session
where sid=853 and serial#=33740;
sid serial# sql_id
-------------------------------
查看是什么SQL语句引发的:
sql> select * from v$sql
where sql_id='...';
让后在KILL
sql>alter system kill session 'sid,#serial'; 这里输入要kill的sid,#serial号码;
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22934571/viewspace-1041956/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22934571/viewspace-1041956/