| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SGA larger than 4GB
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> 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> </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
 |
 |