SELECT s.inst_id,
'ALTER SYSTEM KILL SESSION '''||s.sid||','||s.serial#||''';' hasil,
p.spid,
s.username,
s.program FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id order by s.program;
Then kill it
ALTER SYSTEM KILL SESSION 'sid,serial#';
OR
some example I found online seems to need the instance id as well alter system kill session '130,620,@1';
Tidak ada komentar:
Posting Komentar