Re: Murder mode

Hi Mladen,

THere is a doc about this: New Alert Log Entries In 12.2 Related To Session Kill: KILL SESSION for sid= (Doc ID 2438653.1) It can be:
1. *Mode = KILL HARD SAFE -/-/-* - for 'alter system kill session' 2. *Mode = KILL HARD SAFE DISCONNECT/-/-* for alter system disconnect session
3. *Mode = KILL SOFT* - soft kill by PMON And unfortunately it still doesn't log 'crash', ie 'oradebug event immediate crash'

On Tue, Aug 27, 2019 at 11:21 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Version is Oracle 12.2. I killed a session which had an application
> problem and saw the following log in the alert.log:
>
> KILL SESSION for sid=(8, 43679):
> Reason = alter system kill session
> Mode = KILL HARD SAFE -/-/-
> Requestor = USER (orapid = 225, ospid = 23311, inst = 1)
> Owner = Process: USER (orapid = 224, ospid = 23257)
> Result = ORA-0
>
> What is "KILL HARD SAFE"? What modes are available, what is the meaning of
> particular mode and how do I change the modes? That doesn't seem to be
> documented anywhere.
>
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l