kill session

 select 'orakill ' || instance_name || ' ' || spid as thread from v$process p, v$session s, v$instance i where s.username is not null and p.addr = s.paddr; 

posted @ 2010-03-09 11:19  abenz  阅读(140)  评论(0编辑  收藏  举报