OraFAQ Forum: Unix » Should "max-shm-ids x max-shm-memory"

Home » Infrastructure » Unix » Should "max-shm-ids x max-shm-memory" < RAM size? (Oracle 10.2 on Solaris x86)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Should "max-shm-ids x max-shm-memory" < RAM size? [message #511257]

Fri, 10 June 2011 09:16

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

Report message to a moderator

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

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/

Report message to a moderator

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

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.

Report message to a moderator

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

John Watson
Messages: 8977
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.

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	Scripts that uses cronjobs
Next Topic:	KUP-04063 SQLNET + NFS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 28 03:22:49 CDT 2025