RE: Session Killed...!!

If you kill the unix process associated with this session first, and then the session it will go away.  

Killing sessions in Oracle has always been weird. Sometimes they go away and sometimes not, depending on OS. In Windows, use orakill to kill the session - this always seems to work in windows. And killing the unix session then the Oracle session seems to work just fine in AIX.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chirag DBA Sent: Thursday, September 15, 2005 10:36 AM To: askdba_at_freelists.org; Oracle-L Freelists Subject: Session Killed...!!  

Hi ,  

I saw many users on my database connected for more than 6 days without any activity.  

I killed 1 user and still the status in v$session is showing as killed.  

but it it not getting removed from the v$session.  

I am running 9.0.1.3 on solaris.  

any idea? We already hit the bug ora-07442.  

regards - chirag

--
http://www.freelists.org/webpage/oracle-l