Home » Infrastructure » Unix » Should "max-shm-ids x max-shm-memory" < RAM size? (Oracle 10.2 on Solaris x86)
Should "max-shm-ids x max-shm-memory" < RAM size? [message #511257] Fri, 10 June 2011 09:16 Go to next message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Hi Gurus,

I have one Oracle on Solaris 10. I have 8G physical RAM on this machine.

Could I set max-sh-memory = 8G and max-shm-ids = 100?

From someone comments, seems max-shm-memory times max-shm-id should less physical RAM? Is it correct?

Thank you in advance!
Edgy
Re: Should "max-shm-ids x max-shm-memory" < RAM size? [message #511258 is a reply to message #511257] Fri, 10 June 2011 09:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/install.102/b15697/toc.htm


It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Should "max-shm-ids x max-shm-memory" < RAM size? [message #511261 is a reply to message #511258] Fri, 10 June 2011 09:56 Go to previous messageGo to next message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Thank BlackSwan remind and guide.

I did google search. Unfortunately, I failed to get clear concept and answer about relation of shm-memory and shm-ids. This is a reason why I am asking here. In fact, after posted it, I still working and studying this issue. If I found the value stuff, I would like to put here too.

Thanks again.
Re: Should "max-shm-ids x max-shm-memory" < RAM size? [message #511262 is a reply to message #511257] Fri, 10 June 2011 09:58 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You are setting up the Solaris projects, right? I would do what you have suggested, give the Oracle project access to all the RAM as DISM (dynamic intimate shared memory, for anyone who doesn't know Solaris - I don't know it that well.) One thing you must check later is whether your Oracle processes are running under the correct project, I have had instances fall over after a few days because they weren't. I have found that using
su - oracle
and then starting the instance isn't good enough, it will be running under your project settings, not oracle's. I think you use
prtcl
with a few switches to check this.
Re: Should "max-shm-ids x max-shm-memory" < RAM size? [message #511266 is a reply to message #511262] Fri, 10 June 2011 10:12 Go to previous message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
Yes, I setup the Solaris projects. But, as my mentioned (100x8G), max-shm-ids by max-shm-memory would over physical RAM. Would it cause any issue, such as "out of memory"?

BTW, as you said, must check later is if Oracle processes are running under the correct project. Would you please giving me more hints to how to do? Sorry, I am a bit new in sol world. Anyway, I would search in meantime.
Previous Topic: Scripts that uses cronjobs
Next Topic: KUP-04063 SQLNET + NFS
Goto Forum:
  


Current Time: Thu Mar 28 03:44:42 CDT 2024