In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Thursday, August 6, 2009

Database Created as 32bit Or 64bit Platform

We can check the Database Created as 32bit Or 64bit Platform through below sql query

SQL> select metadata from sys.kopm$ ;


If above Colored Character Is "B023" means 32bit


If it is "B047" means 64bit.


more ways to check oracle is 32 bit or 64 bit by using the following methods

1. You can retrieve this information from the data dictionary view v$version. Banner will tell you 64-bit if the 64-bit version is installed.If it does not specify 64-bit then it is 32-bit (although it does not explicitly say so). Same information you get when login into SQL*PLUS.

SQL> select * from v$version;

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production

2. On Unix, the file command is also available . Example:

ORACLE:/home/oracle>file `which oracle`
/d01/app/oracle/product/10.2.0/db_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped quering v$process view

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


4.Check for lib, lib32

1) $ORACLE_HOME/lib32

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit.

If there is only an ORACLE_HOME/lib directory then it is 32 bit client.


Anonymous said...

Actually this is a bit complex.
Check out .. they provided an easy query which looks up v$process and give you if 32 or 64 upfront.
I cant paste it here .. but google it out !

Rajeshkumar Govindarajan said...

thanks for ur comment friend,
i got more information about this bcoz of u
i have posted that also