Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

shmmax and oracle sga

SOLVED
Go to solution
Highlighted
Heidi Miller
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?
4 REPLIES
Chan 007
Honored Contributor
Solution

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
Court Campbell
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???"
Court Campbell
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???"
Court Campbell
Honored Contributor

Re: shmmax and oracle sga

Please assign points if we were able to help you.

https://community.hpe.com/t5/Community-FAQ/FAQ-Kudos/td-p/6838486

"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???"