topic Re: Sizing the SGA and system KERNEL in Operating System - HP-UX

Sizing the SGA and system KERNEL

George Nikoloudis_1 — Wed, 05 Dec 2001 13:12:14 GMT

Hello
I would like to ask I have a V Class 8 Processors 8 GB Memory. I would like to have an Oracle SGA with 2GB what parameters should I configure in the KERNEL in order to lock the SGA in the memory and swap it?

Thanks alot

Re: Sizing the SGA and system KERNEL

A. Clay Stephenson — Wed, 05 Dec 2001 13:31:26 GMT

Hi George:

I'm not sure what you mean by locking the SGA in memory and swapping it since those terms are mutually exclusive. If you want a large SGA, you will need to increase maxdsiz_64bit to a value somewhat larger then 2GB and build a kernel. You also need to make sure that you have sufficient swap.

Re: Sizing the SGA and system KERNEL

Steven Gillard_2 — Wed, 05 Dec 2001 14:05:57 GMT

See the following thread for information about locking the SGA in memory:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xf853af48a9e5d5118ff40090279cd0f9,00.html

To have a 2Gig SGA you will also need to increase shmmax to 0x7fffffff.

Regards,
Steve