DBA Hub

📋Steps in this guide1/1

Kill all sessions of a sql_id

select 'alter system kill session ' ||''''||SID||','||SERIAL#||' immediate ;' from v$session where sql_id='&sql_id';

oracle configurationintermediate
by OracleDba
11 views
1

Kill all sessions of a sql_id

FOR RAC

Code/Command (click line numbers to comment):

1
2
3
4
select 'alter system kill session ' ||''''||SID||','||SERIAL#||' immediate ;' from v$session
where sql_id='&sql_id';
select 'alter system kill session ' ||''''||SID||','||SERIAL#||',@'||inst_id||''''||' immediate ;'
from gv$session where sql_id='&sql_id'

Comments (0)

Please to add comments

No comments yet. Be the first to comment!