Look in:

Web oracle-core-dba.blogspot.com

Tuesday, April 13, 2010

How to know your Oracle database is 32bit or 64bit?

Method 1:
oracle >cd $ORACLE_HOME/bin
oracle >file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

Method 2:

oracle >sqlplus "/ as sysdba"

SQL*Plus: Release 9.0.1.4.0 - Production on Tue Apr 13 09:21:49 2010

(c) Copyright 2001 Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.0.1.5.0 - Production
With the Partitioning option
JServer Release 9.0.1.4.0 - Production

SQL> select
length(addr)*4 || '-bits' word_length
from
v$process
where
ROWNUM =1; 2 3 4 5 6

WORD_LENGTH
---------------------------------------------
32-bits

The third and the simplest one is while you connect to your database if you find any mentioning of the Platform it is 64bit and if not its 32 bits ;)


64 BITS:

oracle >sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Apr 13 05:35:30 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

32BITS:

oracle >sqlplus "/ as sysdba"

SQL*Plus: Release 9.0.1.4.0 - Production on Tue Apr 13 09:21:49 2010
(c) Copyright 2001 Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.5.0 - Production
With the Partitioning option
JServer Release 9.0.1.4.0 - Production