Killed Session locks table, but has no process (spid)

Hello

Oracle 8i/Solaris

I have a killed session that is locking a process. Searching usenet seems to reveal the common wisdom that in such case one can either a) wait until pmon cleans the session up or b) query v$process for SPID and the kill the according unix process.

In my case neither seems to work. After waiting a long time, I decided to kill the unix process in question but am unable to find its pid:

SQL> select spid,id1 from v$session s, v$process p, v$lock l

     where s.sid=l.sid and s.paddr = p.addr(+) and status='KILLED';

SPID ID1
--------- ----------

                9360

No SPID in sight!

Can someone point me to a solution of this problem?

MK Received on Wed May 22 2002 - 03:39:24 CDT