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

Home -> Community -> Mailing Lists -> Oracle-L -> killed sessions staying around

killed sessions staying around

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 03 Jul 2001 11:57:27 -0700
Message-ID: <F001.003408C1.20010703120543@fatcity.com>

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 BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204 Received on Tue Jul 03 2001 - 13:57:27 CDT

Original text of this message

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