Tom: I wanna know: 1. What do you mean by 32 bit Oracle and 64 bit Oracle? Because in so many Oracle documentation I found '32 bit Oracle 7.x' '64 bit Oracle 7.x' '32 bit Oracle 8.x' '64 bit Oracle 8.x' also sometime in migration related documentaion I found people are talking about 32 bit and 64 bit Oracle.

What I thought there is only one Oracle, I don't understand what is the difference between 32 bit and 64 bit oracle. How this bit concept is related to Oracle? May be you can through some light on this issue. Is there any known issue while migration from 8.0.x(8) to 8.1.x (8i). If yes, can you please let me know?

Thanks San and we said. Hello, We were doing some benchmark experiments and found some interesting case with 32 BIT & 64 BIT Oracle Versions. We create 2 oracle instances (one 32 bit & one 64 bit)on test box.

64-bit ODAC for Windows consists of Oracle client side drivers, including ODP.NET, ODBC, OLE DB, and Oracle Services for MTS.

We developed one script to generate test data. Script was written to generate fixed size data.

Which means after generating X MB data, execution was terminated. On 64 Bit Oracle we found that no.

Of rows generated were higher (approx. 25%) as that of 32 Bit Oracle with same size of data. Which means say for X MB Size, 32 bit ORACLE generated Y rows whereas 64 bit ORACLE generated 1.2Y rows. Can you throw some light on this? I wanted to know if Oracle 9i release 2 (32 bit) supported on 64 bit Sun 5.8 (solaris 8). Found following information on Metalink.

Castells the internet galaxy pdf to word converter. Opening: The Network is the Message 1.: Lessons from the History of the Internet 2.: The Culture of the Internet 3.: e-Business and the New Economy 4.: Virtual Communities or Network Society? How has the Internet affected social and cultural organization, political participation and communication, and urban living? These are just some of the questions addressed in this much needed book. Castells avoids any predictions or prescriptions - there have been enough of those - but instead draws on an extraordinary range of detailed evidence and research to describe what is happening, and to help us understand how the Internet has become the medium of the new network society.

• All Server and O/S versions without 64-bit notations indicate 32-bit versions. • The 64-bit O/S is capable of running programs that were compiled on a 32-bit O/S and 64-bit O/S. • The 32-bit O/S runs only programs that were compiled on a 32-bit O/S.

This is called Binary Compatible. • A 32-bit application will work on both a 32-bit and 64-bit O/S, whereas a 64-bit application will only work on a 64-bit O/S. • Note, however, that re-linking must occur on the O/S version that the application was compiled, as this affects patch sets.

Question -------- What is the meaning of 'Note, however, that re-linking must occur on the O/S version that the application was compiled, as this affects patch sets.' Does it simply mean executing $ORACLE_HOME/bin/relink? What does relink do and how is it related to 32/64 bit problem? How and when should relink happen?

(in this context?). Followup September 07, 2004 - 7:25 am UTC when you install, a 'link' happens. So, if you 'install', it'll link. If on the other hand, you had 32bit on there, upgraded the os from a 32 bit version to a 64 bit version and did not reinstall - you would want to relink. Please contact support (via an itar) for installation and configuration details. I myself do not work on every OS, with every nuance.

They would be the best place for a nitty gritty install detail like this (or even to explain what their note means in detail!). Followup January 26, 2005 - 10:21 am UTC or maybe slower throughput because all pointers take twice as much space and moving the bits around takes longer.

We are having to process MORE bits to do the same work:) 64bits gives you more addressability, the potential for a larger SGA, being able to use more of your RAM. Your choice of 32 or 64bits is driven more by the hardware and OS you are choosing than anything else -- let those choices drive your decision. (and on windows, it isn't the SGA size in as much as the size of the PROCESS that is oracle.exe with all of the threads.). I found that the 64-bit Intel Xeon MP can still operate some of our 32-bit software, which may not yet be compatible with a 64-bit operating system. I have been searching for recent information about 64 bit Intel Chips and compatibility with Oracle 9i.

Is it still true that Oracle 9i is NOT compatible with 64-bit Intel Xeon /Xeon MP) processors? I know they are compatible with Itanium 2's, but the powers that be are somewhat hesitant to jump to 100% 64-bit software and require an Intel/Microsoft solution. If we could use Xeons to do both 32-bit and 64-bit.

Then things may be a little easier to manage. Any feedback would be greatly appreciated. Tom, I'm hoping you can set my mind at ease on this one. We are currently running Oracle 9.2.0.6 (64bit) on AIX 5.3 (64bit) Much to my shock, I found that for the several months we've had the systems (pre-production) online, they have been running the 32 bit kernel.

After some consultation with IBM, I was able to boot into the 64 bit kernel. Thankfully, Oracle behaves exactly as it did before. My suspicions were never aroused due to the fact that Oracle has always reported itself as 64 bit: Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning and OLAP options JServer Release 9.2.0.6.0 - Production My question is, if Oracle has always been reporting itself in 64 bit mode, though the OS was running a 32 bit kernel, is there any worry of having to relink or make any other sort of modification? Or can I trust that if things appear normal, they are? Thanks, Rich Janson. If I ma running solaris OS 64 bit and running oracle 9i (9.2.0.5) When i log into sqlplus this shows: 007-f07: sqlplus '/ as sysdba' SQL*Plus: Release 9.2.0.5.0 - Production on Sun Dec 10 15: Copyright (c) 1982, 2002, Oracle Corporation.