Session marked for kill
会话已通过 ALTER SYSTEM KILL SESSION 标记为终止，但会话尚未完全清理。PMON 进程将完成清理。
SELECT sid, serial#, status, username, program FROM v$session WHERE status = 'KILLED';SELECT s.sid, s.serial#, p.spid FROM v$session s JOIN v$process p ON s.paddr = p.addr WHERE s.status = 'KILLED';