Re: HP-UX 11.0 64Bit and Oracle 8.0.x

I have a V-class server running HP_UX 11/Oracle 805 64bit and want to test migrating one of our warehouses on it. The warehouse is about 1Tb currently running on 804 32 bit. Im using an sga of about 500Mb. Does anyone know of any special parameters I need to introduce to push the buffer caches up past 2Gb? Im a bit unsure on VLM support on HP as all articles I have found only refer to DECUnix. It is ported to HP isnt it? How can you tell this feature is there?

thanks
Kelvin Stingel
Atraxis

In article <6vjs3l$r02_at_cello.hpl.hp.com>,   ruemmler_at_cello.hpl.hp.com (Chris Ruemmler) wrote:
> In article <01bdecdb$eb75c9c0$4ca2410c_at_default>,
> Phil Cook <pncook_at_worldnet.att.net> wrote:
> >I have seen no performance difference between 10.2 and 11. I believe that
> >8.05x on HP-UX 11 supports memory addressing beyond 2 gig.
> >Any Oracle version less on HP-UX will not support greater than
> >2 gig, so you have wasted memory, unless you give it to other
> >processes or to OS cache.
> >
> This is actually not true with Oracle. Oracle allocates a lot of
> per-process data for doing things like sorts and hash-joins. So
> if you are doing DSS type stuff, the 2GB limit is not very real because
> Oracle will allocate more than 2GB of memory, but spread it among
> its worker processes for doing DSS type work. So, if you have
> 50 worker processes, each could allocate up to 1GB of local memory
> thus using a total of 50GB of memory.
>
> All you need is 64-bit HP-UX. You can live with 32-bit Oracle.
> However, 64-bit Oracle will won't have limits on the "global" shared
> area/pools and will be better optimized for PA8xxx processors given it can
> run "newer" instructions vs the 32-bit code.
>
> --Chris
> My own views
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 30 1998 - 00:00:00 CST