Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why KILLED session hang?

ronald_2017Mar 18 2020 — edited Mar 25 2020

Hi All,

I have seen some KILLED status sessions even if I use alter system kill immediate sql, what should I do?

I also try to kill at OS level with ORAKILL ORACLE_SID SPID

What do you recommend?

SELECT sid, paddr, serial# FROM v$session where status = 'KILLED'
1290    0000000664CB13E0    4957

Thanks

This post has been answered by AndrewSayer on Mar 19 2020

Jump to Answer

Added on Mar 18 2020

#general-database-discussions

14 comments

2,579 views