##所有环境均适用
alter system disconnect session '10,7883' immediate;
##linux & unix 环境适用
SELECT 'kill ' || ' -9 ' || p.spid
FROM v$session s
JOIN v$process p ON s.paddr = p.addr
WHERE s.sid=:SID_To_Kill;
##windows 环境适用
SELECT 'orakill ' || sys_context('USERENV', 'DB_NAME') || ' ' || p.spid
FROM v$session s
JOIN v$process p ON s.paddr = p.addr
WHERE s.sid=:SID_To_Kill;