From oracle-l-bounce@freelists.org Wed Jan 12 11:02:22 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0CH2Lb13355 for ; Wed, 12 Jan 2005 11:02:21 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0CH2Ln13350 for ; Wed, 12 Jan 2005 11:02:21 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 95E4A72CD05; Wed, 12 Jan 2005 12:08:57 -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 02106-77; Wed, 12 Jan 2005 12:08:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D9B8F72CD8A; Wed, 12 Jan 2005 12:04:53 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: How do I know if im running 32 bit for windows? Date: Wed, 12 Jan 2005 17:00:12 -0000 Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F6301C5D41F@UKWMXM04> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How do I know if im running 32 bit for windows? Thread-Index: AcT4xj0qcTzCNJNZQSynpdQRdbLZVgAAZMpA From: "Hallas, John, Tech Dev" To: , "Oracle-L" X-OriginalArrivalTime: 12 Jan 2005 17:00:08.0627 (UTC) FILETIME=[2BDD0830:01C4F8C8] X-archive-position: 14702 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: John.Hallas@gb.vodafone.co.uk Precedence: normal Reply-To: John.Hallas@gb.vodafone.co.uk X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Try a select * from v$session.=20 If SADDR is type RAW(4) it is 32 bit if RAW(8) then 64 bit Works on *nix so I assume is the same on Windows. John John Hallas Oracle DBA - Projects Team Data Centre Services, Technology Tel: +44 (0) 16356 77721 E-mail : john.hallas@vodafone.co.uk Vodafone Limited Registered Office : Vodafone House, The Connection, Newbury, Berkshire = RG14 2FN Registered in England No 1471587 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Bryan Wells Sent: Wednesday, January 12, 2005 4:40 PM To: Oracle-L Subject: How do I know if im running 32 bit for windows? Is this showing me running Oracle 32bit? SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production --=20 Bryan S Wells - DBA Newbie bunjibry@gmail.com -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l