Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: killing a 'killed' session
Killed sessions count towards the session parameter in init.ora.
So it might matter if you are hitting the max limit.
Try this (I only advise it for a non-production db since I have never tested this fully!)
... and like I said: use this advise at your own risk.
You'll know that it works, if you find the killed sessions are
decreasing in number (from v$session).
Also, you might need to wait a minute or less for the session to disappear
from v$session.
:)
Anurag
"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:k5sea.1427$8T5.11835448_at_news-text.cableinet.net...
>
> "NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message
> news:3e7a439a.2094599024_at_nyc.news.speakeasy.net...
> > where sid is the sid of a session you're trying to kill (from
> > v$session).
> >
>
> SID SERIAL# USERNAME ROUND(LAST_CALL_ET/60)*60 IDLE
> ---------- ---------- -------------------- ------------------------- -------
> -
> 13 11567 XXXXXXX 1057440 KILLED
>
>
> select p.spid
> 2 from v$process p, v$session s
> where s.paddr = p.addr
> 3 4 and s.sid = &1
> 5 ;
> Enter value for 1: 13
> old 4: and s.sid = &1
> new 4: and s.sid = 13
>
> no rows selected
>
> ?
>
>
Received on Thu Mar 20 2003 - 21:23:40 CST