topic memory windows and oracle in Operating System - HP-UX

memory windows and oracle

Joseph Hoh — Fri, 03 Nov 2000 15:28:23 GMT

Has any one used memory windows on HP-UX 11.0 64bit running Oracle 32bit ver.?

What good things have you seen?
What bad things have you seen?

Do you need to start your Oracle DB using the setmemwindow command?

I have a V2500 with 8GB of RAM. We are running out of shared memory.

Re: memory windows and oracle

John D. Reaney — Fri, 03 Nov 2000 15:32:54 GMT

We are using this - yes you will need to use setmemwindow -

This will work fine if you have multiple databases but if you have one db that you need an sga > 1GB you are still out of luck. Works good to combine a lot of dbs on a V or N or superdome

Re: memory windows and oracle

Schalk Venter — Mon, 06 Nov 2000 11:51:15 GMT

Memory windows is used to overcome the 1 GB shared memory limitations on 32 bit HP-UX implimentations.
Using a V2250 means that you can only be running a 64 bit implementation. This also means that you dont need memory windows to address more than 1GB of shared memory.

I think you should rather have a look at your kernel parameters and increase the size of the SHMMAX parm etc