From Richard.Ji@ztango.com Thu, 26 Jun 2003 11:29:47 -0700 From: "Richard Ji" Date: Thu, 26 Jun 2003 11:29:47 -0700 Subject: RE: RE: SHMMAX setting on Sun 4800 box Message-ID: MIME-Version: 1.0 Content-Type: text/plain Chao, There are couple of ways to confirm whether ISM is used or not. The easiest way on Soalris 8 is run pmap on an Oracle process and you will see "ism" in those shared memory segments. Below I set my SHMMAX to 100m and my SGA to 300m+. 0000040000000000 100000K read/write/exec/shared [ ism shmid=0x2 ] 0000040040000000 100000K read/write/exec/shared [ ism shmid=0x3 ] 0000040080000000 73728K read/write/exec/shared [ ism shmid=0x4 ] 00000400C0000000 40456K read/write/exec/shared [ ism shmid=0x5 ] The better way and correct way is to do what's suggested by "Solaris Internal" to use crash utility to determine whether ISM is used. There is also an article on Steve Adam's web site on how to prove it. Regards, Richard Ji -----Original Message----- Sent: Thursday, June 26, 2003 2:17 PM To: Multiple recipients of list ORACLE-L Richard Ji,您好! Hi , how do you know that ISM is used even if multiple shared memory segment are used in solaris 8? ======= 2003-06-26 09:24:00 您在来信中写道:======= >Matt, > >Your SGA can still be larger than 4G even if SHMMAX is not larger than >4G. When SGA size > SHMMAX, mutilple shared memeory segements will >be allocated. There used to be a claim that if you can fit the SGA >into a single shared memory segment, ISM will be used. This might >be true for older version of Solaris, but I have seen ISM being used >even when mutiple shared memory segments are allocated on Solaris 8. > >Regards, > >Richard > >-----Original Message----- >Sent: Thursday, June 26, 2003 10:55 AM >To: Multiple recipients of list ORACLE-L > > > >As long as you're running 64-bit solaris and 64-bit oracle, you can set >SHMMAX to be larger than 4G, which will allow your SGA to be larger than >4G. Keep an eye on your overall memory pressure, though, to make sure >you don't oversubscribe the system. If you're running Solaris 8/9 >and/or using some sort of direct i/o (raw devices, veritas, etc.) you're >good to go at that point. If you're running 7 or 2.6 (can you even run >2.6 and 7 on the 4800? I doubt it), you'll want to turn on >priority_paging in /etc/system to keep your sga from getting paged out >in favor of filesystem buffers. > >Thanks, >Matt > >-- >Matthew Zito >GridApp Systems >Email: [EMAIL PROTECTED] >Cell: 646-220-3551 >Phone: 212-358-8211 x 359 >http://www.gridapp.com > >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >> Behalf Of Zhai Jingmin >> Sent: Thursday, June 26, 2003 5:34 AM >> To: Multiple recipients of list ORACLE-L >> Subject: SHMMAX setting on Sun 4800 box >> >> >> Hello, List, >> >> Our Sun Fire 4800 server have 8 CPUs and 16G memory.I set the >> SHMMAX kernel parameter to 4294967295 according to >> installation guide on metalink.The SHMMAX is "max shared >> memory segment size".What's the relationship between SHMMAX >> and max size of SGA?Because our oracle's SGA may exceed >> 4G,can I set this parameter to 8G,10G? >> >> Any suggestion is appreciated. >> >> Thanks, >> >> Zhai Jingmin >> [EMAIL PROTECTED] >> 2003-06-26 >> >> >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Zhai Jingmin >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com >> San Diego, California -- Mailing list and web hosting services >> --------------------------------------------------------------------- >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') >> and in the message BODY, include a line containing: UNSUB >> ORACLE-L (or the name of mailing list you want to be removed >> from). You may also send the HELP command for other >> information (like subscribing). >> > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Matthew Zito > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Richard Ji > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = =         致 礼!         chao_ping [EMAIL PROTECTED]           2003-06-27 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).