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

  • From: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
  • To: <bunjibry@xxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Jan 2005 17:00:12 -0000

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@xxxxxxxxxxxxxx

Vodafone Limited
Registered Office : Vodafone House, The Connection, Newbury, Berkshire =
RG14 2FN
Registered in England No 1471587




-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: