摘要: select p.spid, c.object_name, b.session_id, b.oracle_username, b.os_user_name from v$process p, v$session a, v$locked_object b, all_objects c where p.addr = a.paddr and a.process = b.process and c.object_id = b.object_id;--杀掉SESSIONalter system kill session session_id; 阅读全文
posted @ 2011-03-07 13:07 凡庭 阅读(245) 评论(0) 推荐(0) 编辑