摘要:
比如说杀掉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 阅读全文