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 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;

Oracle9i Enterprise Edition Release - Production
PL/SQL Release - Production
CORE       Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

Bryan S Wells - DBA Newbie

Other related posts: