Question: I want
to know of my installation of an Oracle client is 32 bit or 64 bit.
How can you tell if a PC client is running 32bit or 64bit Oracle
Answer: There are two areas; checking the PC
client and checking the Oracle client software installation.
Checking PC client: Because a 64
client will not run on a 32 bit PC, you can check to see if the PC
is 32 or 64 bit in Windows in:
control panel ==> system
operating system 64 bit operating system
In cases where you have a 32-bit on a 64-bit PC, you can check
in installation directory to see of the PC client installation is 32
or 64 bit..
Checking Oracle client software: There are
three methods for checking the Oracle client software. Windows has a different
lib directory for 32-bit software and 64-bit
software. The fastest way to see if an Oracle Client is 64bit
or 32bit, too look for "lib32" and "lib" folders under ORACLE_HOME.
If the Oracle Client is 32 bit, it will contain a "lib" folder;
but if it is a 64 bit Oracle Client it will have both "lib" and "lib32"
Also, starting in Oracle 188.8.131.52, the client
version for 64-bit and the Oracle client for 32-bit are shipped
separately, and there is an $ORACLE_HOME/lib64 directory.
$ORACLE_HOME/lib/ ==> 32
$ORACLE_HOME/lib64 ==> 64 bit
$ORACLE_HOME/lib/ ==> 64 bit
$ORACLE_HOME/lib32 ==> 32 bit
tell if my Oracle server is 32-bit or 64-bit.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.