From oracle-l-bounce@freelists.org Thu Mar 17 02:46:31 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j2H8kUQN001574 for ; Thu, 17 Mar 2005 02:46:30 -0600 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 j2H8kUem001569 for ; Thu, 17 Mar 2005 02:46:30 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3AE2886AF6; Thu, 17 Mar 2005 02:44:49 -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 26236-08; Thu, 17 Mar 2005 02:44:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B46AB865BC; Thu, 17 Mar 2005 02:44:48 -0500 (EST) Message-ID: <30462D80AA52E74698512ADCC4F7EAA31B38AD01@EXCHANGE> From: "Subbiah, Nagarajan" To: "'oracle-l@freelists.org'" Subject: Machine Name as 0.0.0.0 in V$session Date: Thu, 17 Mar 2005 02:43:03 -0500 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 17388 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Nagarajan.Subbiah@aetn.com Precedence: normal Reply-To: Nagarajan.Subbiah@aetn.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: The query 'select username,machine,count(1) from v$session group by username,machine' gives the machine name as '0.0.0.0' for some of the users intermittently especially when there are high number of connections established from the application server. Any idea about why the machine name shows as '0.0.0.0'? These connections goes away in few minutes. It seems to me that some of the disconnected sessions by the applications are hanging in the database and its released after few minutes. The database is on HP-UX 11.11 & Oracle 9.2.0.5. Thanks, Raja. -- http://www.freelists.org/webpage/oracle-l