断开Oracle连接用户

select 'alter system kill session ''' || sid || ',' || serial# || ''';' from v$session where lower(username)='stgis'; alter system kill session '328,21156'; alter system kill session '483,3144'; alter system kill session '513,6606';
posted @ 2012-07-16 18:32  adodo1  Views(128)  Comments(0Edit  收藏  举报