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

Reply via email to