Sizing the SGA and system KERNEL

[George Nikoloudis_1]

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

[A. Clay Stephenson]

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.

[Steven Gillard_2 · Accepted solution]

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