Re: Oracle 8.1.7 (32 and 64 Bit) ?

My experience 3 years ago, so this could have changed since then...

When I looked 3 years ago into 32-bit vs. 64-bit Oracle on Sun Solaris for 8i, everyone I talked to gave a consistent answer.

Anyway, we went with 32-bit Oracle on 64-bit Solaris.

What I found:

1. Oracle 64-bit patches are usually released around 3 months (or more) later than 32-bit.
2. Oracle 64-bit does not give better performance, except indirectly a large SGA means more buffering which might help performance.
3. Oracle 64-bit is a good choice for large databases that require large SGA memory allocations or large number user sessions.
4. Exporting a large file is easier with a 64-bit OS, even if Oracle is 32-bit. See document on export considerations at URL: http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch01.htm#45782

Anyway, I think just about everyone agreed running the 64-bit version of Solaris was a good idea.

-- 
<rc_at_die@you@!spammers.sandworm.demon.co.uk> wrote in message
news:uounpvgm0gdjbpl6nvkd74t8o2fcm31uj5_at_4ax.com...


> I was looking the Oracle site.

> They seem to have two version of Oracle 8.1.7 (64 and 32 bit) for Sun

> Solaris.

>

> Can any one tell me what the difference is between them, I am aware

> that

> Solaris and Sparc chips are 64bit system.

>

> Am I right in understanding the only difference between them is how

> memory is addressed etc and makes no difference to how the Application

> that uses it is compiled ?

>

> Perhaps some one can enlighten me

>

> Thanks

>

>