| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How windows manage memory: oracle
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
winternals software runs a website called sysinternals which has a bunch of useful free utilities for windows (and IIRC Linux now as well). pslist is one of those utilities.
www.sysinternals.com
-----Original Message-----
Yechiel Adar
Sent: 05 December 2003 07:24
To: Multiple recipients of list ORACLE-L
Thanks Paul.
I did a check this week with out Win2000 tech support and was told that
it come with 3GB process size while WNT was limited to 2GB (without
special parameters).
What is this pslist command? Is it something from Unix?
Yechiel Adar
Mehish
Hi.
The 2 GB process limit kicks in well under 2 * 1024 *1024 * 1024.
its between 1.7 and 1.8 GB.
I'm quite familiar with hitting it in win32, as large memory support was
not enabled in every 8.1.7.x patchset. Large memory support sure works
great in 9.2.0.4.
W2K3 Server (not Advanced) ships with large memory support.
In Windows 2000, one needed to acquire Advanced Server edition for large
memory support.
ways that you know that you hit the process memory limit:
For tracking memory usage by a process (namely, oracle.exe), I'd recommend using the sysinternals pslist utility, and log that to an OS file. There is the performance logs option in the OS, which gives you the benefits of setting a max file size which will be filled in a circular fashion.
hth.
Pd
Yechiel Adar <adar76_at_inter.net.il> wrote:
I do not see the problem.
SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB
which
is the upper limit on NT, unless you used special startup parameter.
Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
Sent: Thursday, December 04, 2003 3:24 PM
> Hi, friends:
> Several months ago there is a thread talking about choosing the proper
memory size for windows server running oracle.
> And today I logon to one of my small oracle on NT and found something
I cannot understand. It is a small application running Oracle 817/win2k.
> SGA is 970M and PGA(maxsize) is 40M. Connection is 20.But from task
manager, Oracle is using 1005M physical Memory and 1013M virtual
memory(you
can view the data from here:
>
http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif).
>
>
>
> SQL> show sga
>
>
>
> Total System Global Area 971040796 bytes
>
> Fixed Size 75804 bytes
>
> Variable Size 299798528 bytes
>
> Database Buffers 671088640 bytes
>
> Redo Buffers 77824 byte
>
> SQL> select count(*) from v$session;
>
>
>
> COUNT(*)
>
> ----------
>
> 18
>
> SQL> select sum(value) from v$sesstat where statistic#=(select
statistic#
from v$statname where name='session pga memory max');
>
>
>
> SUM(VALUE)
>
> ----------
>
> 39526196
>
> And I looked at another server running SAP/oracle, get similiar data:
>
> http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif
>
> (780M sga,33 connection and 25M pga).
>
>
>
> Can someone explain it?
>
>
>
> Regards
>
>
>
> Zhu Chao.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: zhu chao
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: adar76_at_inter.net.il 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). _____ Do you Yahoo!? Free <http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/> Pop-Up Blocker - Get it now ------=_NextPart_000_0094_01C3BB1C.91B87850 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <TITLE>Message</TITLE> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><SPAN class=3D042454010-05122003><FONT face=3DArial color=3D#0000ff = size=3D2>winternals software runs a website called sysinternals = which has a=20 bunch of useful free utilities for windows (and IIRC Linux now as well). = pslist=20 is one of those utilities. </FONT></SPAN></DIV> <DIV><SPAN class=3D042454010-05122003><FONT face=3DArial color=3D#0000ff = size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D042454010-05122003><FONT face=3DArial color=3D#0000ff = size=3D2><A=20 href=3D"http://www.sysinternals.com">www.sysinternals.com</A></FONT></SPA= N></DIV> <DIV><SPAN class=3D042454010-05122003><FONT face=3DArial color=3D#0000ff = size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D042454010-05122003><FONT face=3DArial color=3D#0000ff = size=3D2></FONT></SPAN> </DIV> <BLOCKQUOTE dir=3Dltr=20 style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px = solid; MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr = align=3Dleft><FONT=20 face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20 ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] <B>On Behalf Of=20 </B>Yechiel Adar<BR><B>Sent:</B> 05 December 2003 07:24<BR><B>To:</B> = Multiple=20 recipients of list ORACLE-L<BR><B>Subject:</B> Re: How windows manage = memory:=20 oracle<BR><BR></FONT></DIV> <DIV><FONT face=3DArial>Thanks Paul.</FONT></DIV> <DIV><FONT face=3DArial></FONT> </DIV> <DIV><FONT face=3DArial>I did a check this week with out Win2000 tech = support=20 and was told that it come with 3GB process size while WNT was limited = to 2GB=20 (without special parameters).</FONT></DIV> <DIV><FONT face=3DArial>What is this pslist command? Is it something = from=20 Unix?</FONT></DIV> <DIV><FONT face=3DArial></FONT> </DIV> <DIV>Yechiel Adar<BR>Mehish</DIV> <BLOCKQUOTE=20 style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20 <A title=3Ddiscgolfdba_at_yahoo.com = href=3D"mailto:discgolfdba_at_yahoo.com">Paul=20 Drake</A> </DIV> <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20 href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20 </DIV> <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, December 04, = 2003 7:34=20 PM</DIV> <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: How windows = manage memory:=20 oracle</DIV> <DIV><BR></DIV> <DIV>Hi.</DIV> <DIV> </DIV> <DIV>The 2 GB process limit kicks in well under 2 * 1024 *1024 * = 1024.</DIV> <DIV>its between 1.7 and 1.8 GB.</DIV> <DIV>I'm quite familiar with hitting it in win32, as large memory = support=20 was not enabled in every 8.1.7.x patchset. Large memory support sure = works=20 great in 9.2.0.4. </DIV> <DIV>W2K3 Server (not Advanced) ships with large memory support. = </DIV> <DIV>In Windows 2000, one needed to acquire Advanced Server edition = for=20 large memory support.</DIV> <DIV> </DIV> <DIV>ways that you know that you hit the process memory limit:</DIV> <DIV> </DIV> <DIV>1. unable to startup instance</DIV> <DIV>2. unable to spawn a dedicated server process (in = listener.log)</DIV> <DIV>3. unable to allocate <n> bytes of memory in the shared = pool (in=20 the user's error message)</DIV> <DIV> </DIV> <DIV>For tracking memory usage by a process (namely, oracle.exe), = I'd=20 recommend using the sysinternals pslist utility, and log that to an = OS file.=20 There is the performance logs option in the OS, which gives you the = benefits=20 of setting a max file size which will be filled in a circular = fashion.</DIV> <DIV> </DIV> <DIV><A=20 = href=3D"http://www.sysinternals.com">http://www.sysinternals.com</A></DIV=Received on Fri Dec 05 2003 - 04:44:27 CST
>
<DIV> </DIV> <DIV>hth.</DIV> <DIV> </DIV> <DIV>Pd</DIV> <DIV> </DIV> <DIV><BR><BR><B><I>Yechiel Adar <adar76_at_inter.net.il></I></B>=20 wrote:</DIV> <BLOCKQUOTE class=3Dreplbq=20 style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff = 2px solid">I=20 do not see the problem.<BR>SGA is 970M + PGA (20*40) 800 MB + = executables=20 and you got about 2GB which<BR>is the upper limit on NT, unless = you used=20 special startup parameter.<BR><BR>Yechiel Adar<BR>Mehish<BR>----- = Original=20 Message -----<BR>To: "Multiple recipients of list ORACLE-L"=20 <ORACLE-L_at_FATCITY.COM><BR>Sent: Thursday, December 04, 2003 3:24=20 PM<BR><BR><BR>> Hi, friends:<BR>> Several months ago there = is a=20 thread talking about choosing the proper<BR>memory size for = windows server=20 running oracle.<BR>> And today I logon to one of my small = oracle on NT=20 and found something<BR>I cannot understand. It is a small = application=20 running Oracle 817/win2k.<BR>> SGA is 970M and PGA(maxsize) is = 40M.=20 Connection is 20.But from task<BR>manager, Oracle is using 1005M = physical=20 Memory and 1013M virtual memory(you<BR>can view the data from=20 here:<BR>>=20 = http://www.cnoug.org/html/ut/attach/2003/12/04/12516-oramem2-embed.gif).<= BR>><BR>><BR>><BR>>=20 SQL> show sga<BR>><BR>><BR>><BR>> Total System = Global Area=20 971040796 bytes<BR>><BR>> Fixed Size 75804 = bytes<BR>><BR>>=20 Variable Size 299798528 bytes<BR>><BR>> Database Buffers = 671088640=20 bytes<BR>><BR>> Redo Buffers 77824 byte<BR>><BR>> = SQL>=20 select count(*) from v$session;<BR>><BR>><BR>><BR>>=20 COUNT(*)<BR>><BR>> ----------<BR>><BR>> = 18<BR>><BR>>=20 SQL> select sum(value) from v$sesstat where = statistic#=3D(select=20 statistic#<BR>from v$statname where name=3D'session pga memory=20 max');<BR>><BR>><BR>><BR>> SUM(VALUE)<BR>><BR>>=20 ----------<BR>><BR>> 39526196<BR>><BR>> And I looked = at=20 another server running SAP/oracle, get similiar = data:<BR>><BR>>=20 = http://www.cnoug.org/html/ut/attach/2003/12/04/12518-sap-embed.gif<BR>>= ;<BR>>=20 (780M sga,33 connection and 25M = pga).<BR>><BR>><BR>><BR>> Can=20 someone explain it?<BR>><BR>><BR>><BR>>=20 Regards<BR>><BR>><BR>><BR>> Zhu=20 Chao.<BR>><BR>><BR>><BR>><BR>> --<BR>> Please = see the=20 official ORACLE-L FAQ: http://www.orafaq.net<BR>> --<BR>> = Author:=20 zhu chao<BR>> INET: chao_ping_at_vip.163.com<BR>><BR>> Fat = City=20 Network Services -- 858-538-5051 http://www.fatcity.com<BR>> = San Diego,=20 California -- Mailing list and web hosting services<BR>>=20 = ---------------------------------------------------------------------<BR>= >=20 To REMOVE yourself from this mailing list, send an E-Mail = message<BR>>=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and=20 in<BR>> the message BODY, include a line containing: UNSUB=20 ORACLE-L<BR>> (or the name of mailing list you want to be = removed=20 from). You may<BR>> also send the HELP command for other = information=20 (like subscribing).<BR><BR>-- <BR>Please see the official ORACLE-L = FAQ:=20 http://www.orafaq.net<BR>-- <BR>Author: Yechiel Adar<BR>INET:=20 adar76_at_inter.net.il<BR><BR>Fat City Network Services -- = 858-538-5051=20 http://www.fatcity.com<BR>San Diego, California -- Mailing list = and web=20 hosting=20 = services<BR>-------------------------------------------------------------= --------<BR>To=20 REMOVE yourself from this mailing list, send an E-Mail = message<BR>to:=20 ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in<BR>the=20 message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the = name of=20 mailing list you want to be removed from). You may<BR>also send = the HELP=20 command for other information (like subscribing).</BLOCKQUOTE> <P> <HR SIZE=3D1> Do you Yahoo!?<BR><A=20 = href=3D"http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/">= Free=20 Pop-Up Blocker - Get it = now</A></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_0094_01C3BB1C.91B87850-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: niall.litchfield_at_dial.pipex.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).
 |
 |
