Re: Memory usage for Oracle User Process

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Thu, 24 Aug 2000 17:15:20 +0200
Message-Id: <10599.115480@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_067C_01C00DEE.E1B09EC0 Content-Type: text/plain;

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

RE: Memory usage for Oracle User ProcessI bet your SGA is about 280M? The memory-statistics on most machines add the SGA-size to the actual = user-size. So to get this substract.

I've got 60 500Mb user-processes on a 2Gb machine, without swapping.... = It's magic.....

Eric Lansu

Original Message -----=20 From: Koivu, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, 24 August 2000 15:25 Subject: RE: Memory usage for Oracle User Process

Michael, how did you determine that your process is consuming 300M?=20

-----Original Message-----=20
From: Michael Chan [mailto:micchan_at_visto.com]=20 Sent: Thursday, August 24, 2000 8:56 AM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Memory usage for Oracle User Process=20

Hi,=20

I found that some of the Oracle user process consumes memory as high = as 300M. (For a single process only!)=20

Is there any tuning that I can do to control the memory usage on each = user process ?=20

Database is version 8.1.6 on Solaris 2.6=20

TIA,=20
Michael=20

_________________________________________________________________________=

__=20
Visit http://www.visto.com/info, your free web-based communications = center.=20
Visto.com. Life on the Dot.=20

  --=20
  Author: Michael Chan=20
    INET: micchan_at_visto.com=20

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing Lists =

  --------------------------------------------------------------------=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20

------=_NextPart_000_067C_01C00DEE.E1B09EC0 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Memory usage for Oracle User Process</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>I bet your SGA is about =

280M?</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>The memory-statistics on most = machines add the=20
SGA-size to the actual user-size. So to get this substract.</FONT></DIV> <DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>I've got 60 500Mb user-processes on a = 2Gb=20
machine, without swapping.... It's magic.....</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-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 href=3D"mailto:lkoivu_at_qode.com" title=3Dlkoivu_at_qode.com>Koivu, = Lisa</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, 24 August 2000=20 15:25</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Memory usage for = Oracle User=20
  Process</DIV>
  <DIV><BR></DIV>
  <P><FONT size=3D2>Michael, how did you determine that your process is = consuming=20
  300M?</FONT> </P>
  <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From:=20
  Michael Chan [<A=20
  href=3D"mailto:micchan_at_visto.com">mailto:micchan_at_visto.com</A>]</FONT> = <BR><FONT=20
  size=3D2>Sent: Thursday, August 24, 2000 8:56 AM</FONT> <BR><FONT = size=3D2>To:=20
  Multiple recipients of list ORACLE-L</FONT> <BR><FONT = size=3D2>Subject: Memory=20
  usage for Oracle User Process</FONT> </P><BR>

  <P><FONT size=3D2>Hi,</FONT> </P>
  <P><FONT size=3D2>I found that some of the Oracle user process =
consumes memory=20

  as high as 300M.  (For a single process only!)</FONT> </P>   <P><FONT size=3D2>Is there any tuning that I can do to control the = memory usage=20
  on each user process ?</FONT> </P>
  <P><FONT size=3D2>Database is version 8.1.6 on Solaris 2.6</FONT> </P>   <P><FONT size=3D2>TIA,</FONT> <BR><FONT size=3D2>Michael</FONT> = </P><BR>
  <P><FONT=20
=

size=3D2>________________________________________________________________=

___________</FONT>=20
  <BR><FONT size=3D2>Visit <A href=3D"http://www.visto.com/info"=20   target=3D_blank>http://www.visto.com/info</A>, your free web-based=20   communications center.</FONT> <BR><FONT size=3D2>Visto.com. Life on = the=20
  Dot.</FONT> </P>
  <P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Author: Michael = Chan</FONT>=20
  <BR><FONT size=3D2>  INET: micchan_at_visto.com</FONT> </P>   <P><FONT size=3D2>Fat City Network Services    -- (858) =

  538-5051  FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20
  California        -- Public = Internet access=20
  / Mailing Lists</FONT> <BR><FONT=20
=

size=3D2>----------------------------------------------------------------=

----</FONT>=20
  <BR><FONT size=3D2>To REMOVE yourself from this mailing list, send an = E-Mail=20
  message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note EXACT = spelling=20
  of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the message BODY, = include a line=20
  containing: UNSUB ORACLE-L</FONT> <BR><FONT size=3D2>(or the name of = mailing=20
  list you want to be removed from).  You may</FONT> <BR><FONT = size=3D2>also=20 Received on Thu Aug 24 2000 - 10:15:20 CDT