RE: killed sessions staying around

Jeff,

Did you "kill" them via alter system ?

I have found that on NT once you do that you can not get the thread numbers so you can't use orakill.
So either use orakill first before using alter system kill session or at least write down and record the thread numbers so you can use orakill later if required.

pview.exe from the NT4 resource kit will let you look at individual thread information (such as execution time) as will using "tlist oracle" (tlist is also from resource kit).

If you are feeling brave:
Perhaps you could get all the thread ids that the DB knows about then get all the threads in the oracle process via tlist. Perhaps those in the tlist output but not known about by the DB are those that can be killed?

Regards,
Bruce Reardon

-----Original Message-----
Sent: Wednesday, 4 July 2001 6:06

Killed several sessions, but none will terminate. All were connected via ODBC. Users have rebooted, etc. These sessions are several days old and killed today. Was going to try ORAKILL, but there is no thread number. Apparently, entry is on v$session but no corresponding row in v$process. Oracle only suggestion is to exit application gracefully. Oh yeah, like I can enforce that - don't touch the power off switch.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).