From oracle-l-bounce@freelists.org Thu Sep 15 09:56:33 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8FEuWI8017844 for ; Thu, 15 Sep 2005 09:56:33 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8FEuO6H017809 for ; Thu, 15 Sep 2005 09:56:30 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 176F01ED241; Thu, 15 Sep 2005 09:56:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21709-04; Thu, 15 Sep 2005 09:56:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 85B441ED234; Thu, 15 Sep 2005 09:56:16 -0500 (EST) Message-ID: <810139D60775D71191B100306E058F2101914B9D@budco_exch2.budco.com> From: "Chen, Sarah" To: "'Thomas.Mercadante@labor.state.ny.us'" , "'chiragdba@gmail.com'" , "'Oracle-L Freelists'" Subject: RE: Session Killed...!! Date: Thu, 15 Sep 2005 10:54:01 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5BA04.D4B92F4E" X-archive-position: 25494 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Sarah_Chen@BUDCO.com Precedence: normal Reply-To: Sarah_Chen@BUDCO.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.3 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_BLUE,HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE, NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------_=_NextPart_001_01C5BA04.D4B92F4E Content-Type: text/plain I always check process id as well as sid and serial# while killing a session from Oracle. I will always query v$session before and after, and if the status of v$session marked "killed", and then I will go ahead kill OS process to clean this session. It always works on Solaris. Sarah -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mercadante, Thomas F (LABOR) Sent: Thursday, September 15, 2005 10:47 AM To: chiragdba@gmail.com; Oracle-L Freelists Subject: 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Chirag DBA Sent: Thursday, September 15, 2005 10:36 AM To: askdba@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 ------_=_NextPart_001_01C5BA04.D4B92F4E Content-Type: text/html

I always check process id as well as sid and serial# while killing a session from Oracle.

I will always query v$session before and after, and if the status of v$session marked "killed", and then I will go ahead kill OS process to clean this session. It always works on Solaris.

Sarah

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Thursday, September 15, 2005 10:47 AM
To: chiragdba@gmail.com; Oracle-L Freelists
Subject: 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Chirag DBA
Sent: Thursday, September 15, 2005 10:36 AM
To: askdba@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

------_=_NextPart_001_01C5BA04.D4B92F4E-- -- http://www.freelists.org/webpage/oracle-l