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