查找被kill掉的session的操作系统进程号

11g之前:

11g之后:

参考:
How To Find The Process Identifier (pid, spid) After The Corresponding Session Is Killed? (Doc ID 387077.1)

相关文章

一条评论

  1. –11G下我使用的脚本:

    SELECT ‘kill -9 ‘ || spid kill_spid, program
    FROM v$process
    WHERE addr = (SELECT creator_addr
    FROM v$session
    WHERE status = ‘KILLED’);

发表评论

电子邮件地址不会被公开。 必填项已用*标注