RE: How do I know if im running 32 bit for windows?

From: Hallas, John, Tech Dev <John.Hallas_at_gb.vodafone.co.uk>
Date: Wed, 12 Jan 2005 17:00:12 -0000
Message-ID: <1C6E45ADB2EC324F9553E468ABFE0F6301C5D41F@UKWMXM04>

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_at_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_at_freelists.org
[mailto:oracle-l-bounce_at_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_at_gmail.com
--

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

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 12 2005 - 11:02:22 CST