BEGIN
FOR c IN (
SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program,
s.machine,
s.process,
s.status,
s.schemaname
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND' and s.USERNAME='FBCI5IT'
)
LOOP
EXECUTE IMMEDIATE 'alter system kill session ''' || c.sid || ',' || c.serial# || '''';
END LOOP;
END;
Oracle
Disconnect sessions:
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment