Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SGA larger than 4GB

SGA larger than 4GB

From: chao_ping <chao_ping_at_vip.163.com>
Date: Thu, 24 Oct 2002 05:29:03 -0800
Message-ID: <F001.004F243B.20021024052903@fatcity.com>

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_at_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
=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_at_vip.163.com
=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_at_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&gt; 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_at_vip.163.com">chao_ping_at_vip.163.com</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>&nbsp;</DIV></DIV></BODY></HTML>

--=====002_Dragon320551784160_=====--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.com

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: ListGuru_at_fatcity.com (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).
Received on Thu Oct 24 2002 - 08:29:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US