Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: killing a 'killed' session

Re: killing a 'killed' session

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 20 Mar 2003 22:23:40 -0500
Message-ID: <v7l1e17jhs3aec@corp.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US