Skip to Main Content

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!

spid does not show in linux

Ayman2Oct 19 2018 — edited Oct 19 2018

Anyone know why the spid value I see in oracle query does not show in Linux?

I have to kill the session using "kill -9 spid" because Oracle won't kill the session normally as I have used kill session and disconnect commands over 2 days ago and nothing dead.

The session only has a select statement I am killing. no rollbacks, no dml.

Environment Oracle 11gR2 RAC, Linux 6.7

pastedImage_1.png

spid 64506 does not exist in linux OS, anyone know why?

pastedImage_0.png

No Rows selection

pastedImage_8.png

FYI: This is a new question so I'm creating a new post. Previous post was a different question Session marked for kill for many days

Comments
Post Details
Added on Oct 19 2018
6 comments
700 views