Re: shmmax and oracle sga (369 Views)
Reply
Occasional Visitor
Heidi Miller
Posts: 1
Registered: ‎03-15-2007
Message 1 of 5 (369 Views)
Accepted Solution

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?
Please use plain text.
Honored Contributor
Chan 007
Posts: 749
Registered: ‎12-06-2005
Message 2 of 5 (369 Views)

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
Please use plain text.
Honored Contributor
Court Campbell
Posts: 1,605
Registered: ‎08-12-2004
Message 3 of 5 (369 Views)

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???"
Please use plain text.
Honored Contributor
Court Campbell
Posts: 1,605
Registered: ‎08-12-2004
Message 4 of 5 (369 Views)

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???"
Please use plain text.
Honored Contributor
Court Campbell
Posts: 1,605
Registered: ‎08-12-2004
Message 5 of 5 (369 Views)

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???"
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation