Just log into the database using sqlplus and it will tell you
/u01/app/oraclesqlplus /
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit
If 64 bit then
Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production
else
Oracle9i Enterprise Edition Release 9.0.1.2.0
end if;
Vikas Khanna
-Original Message-
Sent: Tuesday, July 23, 2002 3:54 PM
To: Multiple recipients of list ORACLE-L
Just log into the
As someone mentioned on the list, not too recently, use the following command:
file $ORACLE_HOME/bin/oracle
On my machine with 32 bit Oracle, I get:
/keg2/oracle/product/8.1.7/bin/oracle: ELF 32-bit MSB executable SPARC Version 1,
dynamically linked, not stripped
HTH
Kevin Kennedy
First Point
Dear DBAs
How can I know my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to 8g
memory on aix 4.3.3.
The limit is 2gb for 32bit ?
I only know if you switch from 32bit to 64bit or vice-a-versa, then you
also need to run UTLIRP.SQL script
Easiest way I know is do a select * from v$session, if the session id is 8
digits your running 32 bit, if it is 16 your running 64 bit.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original
recipients of list ORACLE-L
Subject: Re: Oracle 32bit / 64bit
Dear DBAs
How can I know my Oracle running on 32 or 64bit ?
I am considering change configuration of SGA. Currently OS is updated to
8g
memory on aix 4.3.3.
The limit is 2gb for 32bit ?
I only know if you switch from
Actually, as soon as you sign onto SQL*Plus is good enough.
Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production
Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production
Note the difference between the two.
-Original Message-
Sent: Tuesday, July 17, 2001 1:00 PM
To:
