Showing results for 
Search instead for 
Do you mean 

shmmax and oracle sga

SOLVED
Go to Solution
Occasional Visitor

shmmax and oracle sga

We are currently running oracle 9.2.0.5, hp-ux 11.11i. We have 28G of physical memory on an rp8400. Currently the shmmax kernel parm is set at 2G. I would like to increase but am not sure by how much. The current size of the SGA is just under 4G. Also, if I increase the shmmax are there any additional parms that should be increased along with it?
1 ACCEPTED SOLUTIONS
Honored Contributor Honored Contributor

Re: shmmax and oracle sga

Please see the link about all the KP and their use

http://docs.hp.com/en/939/KCParms/KCparams.OverviewAll.html

Also I recon check wuth Oracle

Chan
4 REPLIES
Honored Contributor Honored Contributor

Re: shmmax and oracle sga

Please see the link about all the KP and their use

http://docs.hp.com/en/939/KCParms/KCparams.OverviewAll.html

Also I recon check wuth Oracle

Chan
Honored Contributor Honored Contributor

Re: shmmax and oracle sga

In my personal opinion you should set shmmax to a little greater than the size of the sga. This way the sga will fit in one shared memory segment. In your current case it would be using 2 shared memory segments to hold the sga. take a look at this:

http://orafaq.com/node/8

check out the section titled SHARED MEMORY ALLOCATION.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Honored Contributor Honored Contributor

Re: shmmax and oracle sga

P.S. Oracle recommends setting shmmax to the size of available physical memory. That is just ridiculous.
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"
Highlighted
Honored Contributor Honored Contributor

Re: shmmax and oracle sga

Please assign points if we were able to help you.

http://forums1.itrc.hp.com/service/forums/helptips.do?#35
"The difference between me and you? I will read the man page." and "Respect the hat." and "You could just do a search on ITRC, you don't need to start a thread on a topic that's been answered 100 times already." Oh, and "What. no points???"