Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Killed Session locks table, but has no process (spid)
This probably means that shadow already died and pmon is cleaning up
the session. Check v$transaction to see if this is the case.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Marcel Kraupp" <marcel.kraupp_at_gmx.ch> wrote in message news:332bb004.0205220039.74f0f1ea_at_posting.google.com...Received on Wed May 22 2002 - 07:07:39 CDT
> 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