oracle session status killed,kill session V$SESSION标记为KILLED 的2种情况
If the session is not making a SQL call to Oracle (is INACTIVE) when it is terminated, the ORA-28 message is not returned immediately. The message is not returned until the user subsequently attempts …