摘要: 比如说杀掉cyrole用户的所有连接----在p/lsql的测试窗口中执行:declarebegin for temp in ( select username,sid,serial# from v$session s where s.USERNAME='CYROLE' ) loop dbms_output.put_line('alter system kill session '''||to_char(temp.sid)||','||to_char(temp.serial#)||''';'); e 阅读全文
posted @ 2012-09-05 22:54 倚楼听雨 阅读(917) 评论(0) 推荐(0) 编辑