Re: 32bit to 64bit migration

From: Dave A <dave_and_vanna_at_hotmail.com>
Date: Mon, 18 Sep 2000 05:57:47 -0500
Message-ID: <ssbssf3ih3t106@corp.supernews.com>

There is no good reason for a SGA larger than 2g. In fact a 2 gb SGA will almost certainly kill your performance. There is simply too much overhead maintaining it.

Are your hit ratio's low?

--
Dave A


<xiangz_at_rocketmail.com> wrote in message news:8q4n2r$sa5$1_at_nnrp1.deja.com...


> Hi all,

>

> I installed a 32 bit oracle 8.1.5 on HPUX 11(64bit OS), then I found

> out that the SGA size can't excced 2G due to 32 bit limitation. Now I

> would like to migrate oracle 8.1.5 32 bit to oracle 8.1.5 64 bit.

> Is it possible to reuse all the data file directly? How about the

> control file?

>

> What's the simplest way and safest way to do this?

>

> Or I have to export all the data out, and import to new 64 bit database?

>

> Any hints, suggestion?

>

> -Xiang Zhao

>

>

>

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Mon Sep 18 2000 - 05:57:47 CDT