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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sizing of Memory Structures

RE: Sizing of Memory Structures

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Fri, 22 Sep 2000 18:47:01 -0700
Message-Id: <10627.117706@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02500.2B2C9C20
Content-Type: text/plain

Assuming "Memory Structures" to mean SGA, PGA and UGA...

  1. Based on your environment, application and hardware potential (which, by the way, is determined by your budget, projected and estimated needs). That's what tuning and sizing is all about.
  2. What's normal?
  3. The answer should be "no", but I find NT handles memory not as efficiently as Unix. visit www.unix-vs-nt.org the kirch paper
  4. I never needed those sites because I never encountered a standard install.

Regards,
Satar

> -----Original Message-----
> From:	Sanjay Kumar [SMTP:ora_user_at_hotmail.com]
> Sent:	Saturday, September 23, 2000 1:14 AM
> To:	Multiple recipients of list ORACLE-L
> Subject:	Sizing of Memory Structures
> 
> Hi,
>  
> 1. On what basis do I need to size the memory structures?
> 2. What is the normal size that is set to memory structures?
> 3. Does it depend on the O.S?
> 4. Can I find any site where these cases have been studied and posted?
>  
> Help appreciated.
>  
> TIA
> Sanjay Kumar

------_=_NextPart_001_01C02500.2B2C9C20
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Sizing of Memory Structures</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Assuming =
&quot;Memory Structures&quot; to mean SGA, PGA and UGA...</FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">1. Based on your =
environment, application and hardware potential (which, by the way, is = determined by your budget, projected and estimated needs). That's what = tuning and sizing is all about.</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">2. What's =
normal?</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">3. The answer =
should be &quot;no&quot;, but I find NT handles memory not as = efficiently as Unix. visit&nbsp; www.unix-vs-nt.org&nbsp; the kirch = paper</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">4. I never needed =
those sites because I never encountered a standard install.</FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Satar</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Sanjay Kumar [SMTP:ora_user_at_hotmail.com]</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Saturday, September 23, 2000 1:14 AM</FONT>
<BR><B><FONT SIZE=3D1 =

FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=3D1 =

FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>=
</B> <FONT SIZE=3D1 FACE=3D"Arial">Sizing of Memory Structures</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi,</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">1. On what basis do I need to size =
the memory structures?</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">2. What is the normal size that is =
set to memory structures?</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">3. Does it depend on the O.S?</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">4. Can=A0I find any site where these =
cases have been studied and posted?</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Help appreciated.</FONT>
<BR><FONT FACE=3D"Arial">=A0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">TIA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Sanjay Kumar</FONT>
Received on Fri Sep 22 2000 - 20:47:01 CDT

Original text of this message

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