If you are running AIX, a patch is required but it is
essentialy an upgraded version of rootpre.sh that is
run independently.
- Ken Payton <Ken.Payton_at_choicepointprg.net> wrote:
> 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
>
>
>
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
>
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Apr 27 2004 - 16:26:50 CDT