SQL>spool killsess.sql
SQL> set heading off
SQL> select 'alter system kill session ' || '''' || s.sid ||','||s.serial# ||''''||';'
2 from v$session s, v$process p
3 ,v$session_wait w
4 where p.addr = s.paddr
5 and s.sid = w.sid
6 and s.status = 'INACTIVE'
7 /
alter system kill session '541,43';
alter system kill session '148,65';
alter system kill session '347,1';
alter system kill session '53,15';
alter system kill session '102,34';
alter system kill session '249,306';
alter system kill session '299,13';
7 rows selected.
SQL>
SQL>
SQL> spool off;
SQL> set heading off
SQL> select 'alter system kill session ' || '''' || s.sid ||','||s.serial# ||''''||';'
2 from v$session s, v$process p
3 ,v$session_wait w
4 where p.addr = s.paddr
5 and s.sid = w.sid
6 and s.status = 'INACTIVE'
7 /
alter system kill session '541,43';
alter system kill session '148,65';
alter system kill session '347,1';
alter system kill session '53,15';
alter system kill session '102,34';
alter system kill session '249,306';
alter system kill session '299,13';
7 rows selected.
SQL>
SQL>
SQL> spool off;
SQL>
SQL>@killsess.sql
SQL>@killsess.sql
No comments:
Post a Comment