Menu
OS: Windows 2008 Server R2
Oracle Client: 11.2
Many Thanks
721
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" folders.
Hi, In the sql plus prompt type. SQL> select * from v$version; You will get your oracle client verison.
Oracle Instant Client Downloads for Microsoft Windows (x64) 64-bit.
A: No. The 64-bit version simply allows your program to use more memory. There is no real advantage to 64-bit unless you want to fetch a one-billion-row table all into memory on your PC within a Toad data grid.
A simple way to find this out in Windows is to run SQLPlus from your Oracle homes's bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you'll see a process on the Processes tab that looks like this:
sqlplus.exe *32 If it is 64-bit, the process will look like this:
sqlplus.exe Go to %ORACLE_HOME%\inventory\ContentsXML folder and open comps.xml file
Look for <DEP_LIST> on ~second screen.
If following lines have
PLAT="NT_AMD64" then this Oracle Home is 64 bit.PLAT="NT_X86" then - 32 bit.
22
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
