This is a multi-part message in MIME format. --=====002_Dragon320551784160_===== Content-Type: text/plain; charset="GB2312" Content-Transfer-Encoding: quoted-printable
hi, list friends: About SGA , shmmax, ISM on solaris Sun Solaris 7 64bit oracle Unix Kernel Parameter: /etc/system set shmsys:shminfo_shmmax=3D4294967295 Unix kernel statistics; oracle@main-db1$ipcs -ma IPC status from as of Thu Oct 24 20:23:25 CST 2002 T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGSZ CPID LPID= ATIME DTIME CTIME Shared Memory: m 0 0x500483d0 --rw-r--r-- root root root root 1 68 305 305= 6:31:42 6:31:42 6:31:42 m 101 0x41180c94 --rw-r----- oracle oinstall oracle oinstall 398= 4711727104 1732 8979 20:20:00 20:20:00 8:30:38 Current database sga: 19:57:31 SQL> show sga Total System Global Area 4711026364 bytes Fixed Size 102076 bytes Variable Size 415678464 bytes Database Buffers 4294967296 bytes Redo Buffers 278528 bytes As the document said, if the sga is larger than shmmax, oracle= will allocate more than one shared memory segment,right? But in my case, as you can see,SGA =3D 4.7Gb, shmmax =3D4GB As the document said, oracle should allocate two shared memory= segment. but from the ipcs result we can see that there is just one shared= memory segment. How can i understand it? And, can i enlarger the parameter shmmax larger than 4GB? I have= 12Gb physical memory.I never see parameter shmmax larger than= 4GB in any document so not sure. Thanks. =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping [EMAIL PROTECTED] =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-24 --=====002_Dragon320551784160_===== Content-Type: text/html; charset="GB2312" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Dgb2312"= http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR></HEAD> <BODY bgColor=3D#eaeaea> <P><FONT size=3D2><FONT face=3D=CB=CE=CC=E5>hi, list= friends:</FONT></FONT></P> <P><FONT size=3D2><FONT face=3D=CB=CE=CC=E5><FONT= face=3Dverdana,arial,helvetica size=3D1><B>About SGA , shmmax, ISM on solaris</B></FONT> </P> <P><FONT face=3D"verdana, arial, helvetica" size=3D2>Sun Solaris 7= 64bit oracle<BR><BR>Unix Kernel Parameter:<BR>/etc/system<BR>set shmsys:shminfo_shmmax=3D4294967295<BR><BR>Unix kernel statistics;<BR>oracle@main-db1$ipcs -ma<BR>IPC status from= <RUNNING system>as of Thu Oct 24 20:23:25 CST 2002<BR>T ID KEY MODE OWNER GROUP CREATOR= CGROUP NATTCH SEGSZ CPID LPID ATIME DTIME CTIME <BR>Shared Memory:<BR>m 0= 0x500483d0 --rw-r--r-- root root root root 1 68 305 305 6:31:42 6:31:42= 6:31:42<BR>m 101 0x41180c94 --rw-r----- oracle oinstall oracle oinstall 398= 4711727104 1732 8979 20:20:00 20:20:00 8:30:38<BR><BR>Current database= sga:<BR>19:57:31 SQL> show sga<BR><BR>Total System Global Area 4711026364 bytes<BR>Fixed= Size 102076 bytes<BR>Variable Size 415678464 bytes<BR>Database Buffers= 4294967296 bytes<BR>Redo Buffers 278528 bytes<BR>As the document said, if= the sga is larger than shmmax, oracle will allocate more than one shared memory segment,right?<BR><BR><BR>But in my case, as you can see,SGA =3D= 4.7Gb, shmmax =3D4GB<BR><BR>As the document said, oracle should allocate two= shared memory segment.<BR>but from the ipcs result we can see that there is= just one shared memory segment.<BR>How can i understand it?</FONT></P> <P><FONT face=3DVerdana>And, can i enlarger the parameter shmmax= larger than 4GB? I have 12Gb physical memory.I never see parameter shmmax larger= than 4GB in any document so not sure.</FONT></P> <P><FONT face=3DVerdana>Thanks.</FONT></P></FONT></FONT> <DIV> <DIV><FONT face=3D=CB=CE=CC=E5= size=3D2>=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1chao_ping</FONT></DIV> <DIV><FONT face=3D=CB=CE=CC=E5 size=3D2><FONT face=3D=CB=CE=CC=E5= size=3D2>=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1</FONT><A href=3D"mailto:chao_ping@;vip.163.com">[EMAIL PROTECTED]</A></FO= NT></DIV> <DIV><FONT face=3D=CB=CE=CC=E5= size=3D2>=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-10-24</FONT></DIV>= <DIV> </DIV></DIV></BODY></HTML> --=====002_Dragon320551784160_=====-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).