ok , so
I am on 11g,
an I am trying to figure out why some sessions don't have SPID when they are killed,
they just continue to be in status='KILLED' but dont have corresponding SPID.
But at the same time other do have.
I noticed that is true manly to sessions which were not executing anything, they were inactive when killed,
and that sessions don' have spid.
Those who were active when killed seemed to have spid.
?