From oracle-l-bounce@freelists.org Thu Sep 15 09:48:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8FEmjel016312 for ; Thu, 15 Sep 2005 09:48:45 -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 j8FEmb6H016283 for ; Thu, 15 Sep 2005 09:48:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0B5CB1ECC80; Thu, 15 Sep 2005 09:48:31 -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 19885-04; Thu, 15 Sep 2005 09:48:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B9311ECD38; Thu, 15 Sep 2005 09:48:30 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5BA04.44C2BCFF" Subject: RE: Session Killed...!! Date: Thu, 15 Sep 2005 10:46:34 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Session Killed...!! thread-index: AcW6Ax2j6IcWbHPvTvq+9CAAnXx6ZQAANd7A From: "Mercadante, Thomas F (LABOR)" To: , "Oracle-L Freelists" X-OriginalArrivalTime: 15 Sep 2005 14:46:35.0306 (UTC) FILETIME=[452BC8A0:01C5BA04] X-archive-position: 25493 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Thomas.Mercadante@labor.state.ny.us Precedence: normal Reply-To: Thomas.Mercadante@labor.state.ny.us 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=-3.2 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE,NORMAL_HTTP_TO_IP autolearn=no version=2.63 ------_=_NextPart_001_01C5BA04.44C2BCFF Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable If you kill the unix process associated with this session first, and then the session it will go away. =20 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. =20 ________________________________ 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...!! =20 Hi , =20 I saw many users on my database connected for more than 6 days without any activity. =20 I killed 1 user and still the status in v$session is showing as killed. =20 but it it not getting removed from the v$session. =20 I am running 9.0.1.3 on solaris. =20 any idea? We already hit the bug ora-07442. =20 regards - chirag ------_=_NextPart_001_01C5BA04.44C2BCFF Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.44C2BCFF-- -- http://www.freelists.org/webpage/oracle-l