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

Although not much help now, always record the unix process id before knocking a session on its
head with 'alter system kill session'. Then hack it down from unix with a kill once it looks like its not going away. Comparing the creation dates from v$session and the unix pid from ps may be able to help determine which one it is.

Alun

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:acg1m2$k70$1_at_babylon.agtel.net...
> 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_at_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...
> > 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 - 13:00:15 CDT