Re: 32bit to 64bit migration

From: Adrian Shepherd <theshepherds_at_hotmail.com>
Date: Mon, 18 Sep 2000 11:11:56 GMT
Message-ID: <0Mmx5.12718$tj4.92084@news-server.bigpond.net.au>

Interesting comment Dave,

I have a feeling you are spot on, but I am unable to offer any convincing evidence to the businesses concerned, do you have anything concrete, URL's, personal experience, examples ?

Regards

Adrian

"Dave A" <dave_and_vanna_at_hotmail.com> wrote in message news:ssbssf3ih3t106_at_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 - 06:11:56 CDT