| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 32 bit/64 bit datafile?
The difference between 32bit and 64bit is the memory structures, ie. it =
allows a larger than 4GB SGA. The bit version of the database does not =
modify the blocksize or datafile structures that I am aware of. In fact =
I believe you can move your database from 32bit to 64bit with few =
changes. I believe it is as simple as changing your ORACLE_HOME to the =
64bit tree(assuming you have already installed it), runing the catalog =
scripts and recompile all pl/sql. No data conversions are necessary. =20
Kenny Payton
ChoicepointPRG
Sr. Database Administrator
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of jtesta_at_dmc-it.com
Sent: Monday, April 26, 2004 4:02 PM
To: oracle-l_at_freelists.org
Subject: 32 bit/64 bit datafile?
I know this was discussed in years gone by but I can't find the saved = info:
A database was "upgraded" (changed word size) from 32 -> 64 bit.
Without rebuilding the tablespaces/datafiles, my understanding is you don't gain much in the performance arena.
Will a dump of a datafile header prove that it was originally created =
w/32
bit oracle?
thanks, joe
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |