| 32-bit or 64-bit Oracle [message #50627] |
Tue, 26 March 2002 14:19  |
Dennis Wolfe
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
|
We are running a Sun 6500 with Solaris 8 in 64-bit mode. For queries that access large numbers of rows, should we be running 32-bit Oracle or 64-bit Oracle? The server has 12 processors and 12 GB of memory and only runs the Oracle engine.
|
|
|
|
| Re: 32-bit or 64-bit Oracle [message #50632 is a reply to message #50627] |
Wed, 27 March 2002 09:16  |
Farrukh
Messages: 15
Registered: February 2002
Location: Pakistan
|
Junior Member |
|
|
To check whether you are running 32 bit or 64 bit Oracle, login to sqlplus and type:
select * from v$version;
or cd to $ORACLE_HOME/bin and type:
file oracle
The above will tell you whether your oracle is 32 or 64 bit.
Cheers!
Farrukh
|
|
|
|
| Re: 32-bit or 64-bit Oracle [message #50646 is a reply to message #50627] |
Thu, 28 March 2002 07:58 |
Dennis Wolfe
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
|
Thanks, Farrukh. But my question was not how to find out what we are running (we are running 32-bit), but should we be running 64-bit? It seems like 64-bit would perform better given the opportunity to use a larger SGA. However, our DBAs are saying that 32-bit will perform better. This doesn't seem logical.
|
|
|
|
| Re: 32-bit or 64-bit Oracle [message #51126 is a reply to message #50627] |
Tue, 30 April 2002 09:34 |
Robert Schneider
Messages: 1
Registered: April 2002
|
Junior Member |
|
|
Dennis,
You should run 64-bit Oracle. 32-bit has a memory limitation that will prevent you from utilizing the ram in the box. 64-bit is slightly slower but tradeoff is worth it.
- Robert Schneider
|
|
|
|
| Re: 32-bit or 64-bit Oracle [message #52511 is a reply to message #50627] |
Fri, 26 July 2002 10:01 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
So Dennnis, have you decided on 32-bit or 64-bit Oracle ? Any new findings ?
I am alos planning to go from 32-bit Oracle 8.1.6 to 64-bit Oracle 8.1.7. Then eventually go to 9.0.2, 64-bit of coarse. We are running AIX 4.3.3 and will also be moving to 5L soon.
Any feedback will be appreciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
