| 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: Memory usage for Oracle User Process
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_01C00E94.02E754BC
Content-Type: text/plain;
charset="iso-8859-1"
Micheal, this bit me in the butt last year. Oracle client processes on Solaris will reflect the size of the SGA along with any memory it has allocated only for itself. IN my particular 'problem' I had a db with a 700MB SGA, and the SA freaked out one day and asked me why all the client processes for this db had 710MB memory allocated. Well, it didn't make sense because when we added up all the memory that would have been allocated to this database along with the SGA's of the other databases, it exceeded the total memory of the box. Subtract the SGA size from your client memory total and you should end up with a more realistic number.
Hope this helps.
Lisa
-----Original Message-----
From: Michael Chan [mailto:micchan_at_visto.com]
Sent: Friday, August 25, 2000 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Memory usage for Oracle User Process
Sorry Lyall,
The mail should be address to Lisa.
-----Original Message-----
Sent: Thu, 24 Aug 2000 05:25:10 -0800
To: ORACLE-L_at_fatcity.com
Michael, how did you determine that your process is consuming 300M?
-----Original Message-----
Sent: Thursday, August 24, 2000 8:56 AM
To: Multiple recipients of list ORACLE-L
Hi,
I found that some of the Oracle user process consumes memory as high as 300M. (For a single process only!)
Is there any tuning that I can do to control the memory usage on each user process ?
Database is version 8.1.6 on Solaris 2.6
TIA,
Michael
-- Author: Michael Chan INET: micchan_at_visto.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ___________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot. -- Author: Michael Chan INET: micchan_at_visto.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). ------_=_NextPart_001_01C00E94.02E754BC Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Fri Aug 25 2000 - 07:57:23 CDT
<!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: Memory usage for Oracle User Process</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Micheal, this bit me in the butt last year. =
Oracle client processes on Solaris will reflect the size of the SGA = along with any memory it has allocated only for itself. IN my = particular 'problem' I had a db with a 700MB SGA, and the SA freaked = out one day and asked me why all the client processes for this db had = 710MB memory allocated. Well, it didn't make sense because when = we added up all the memory that would have been allocated to this = database along with the SGA's of the other databases, it exceeded the = total memory of the box. Subtract the SGA size from your client = memory total and you should end up with a more realistic number. =
</FONT></P>
<P><FONT SIZE=3D2>Hope this helps.</FONT>
<BR><FONT SIZE=3D2>Lisa</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Michael Chan [<A =
HREF=3D"mailto:micchan_at_visto.com">mailto:micchan_at_visto.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, August 25, 2000 6:43 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Memory usage for Oracle User =
Process</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Sorry Lyall,</FONT>
</P>
<P><FONT SIZE=3D2>The mail should be address to Lisa.</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Thu, 24 Aug 2000 05:25:10 =
-0800</FONT>
<BR><FONT SIZE=3D2>To: =
ORACLE-L_at_fatcity.com</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Michael, how did you determine that your process is =
consuming 300M?</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, August 24, 2000 8:56 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</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 as high as</FONT>
<BR><FONT SIZE=3D2>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 on each user</FONT>
<BR><FONT SIZE=3D2>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 =
SIZE=3D2>_______________________________________________________________= ____________</FONT>
<BR><FONT SIZE=3D2>Visit <A HREF=3D"http://www.visto.com/info" =
TARGET=3D"_blank">http://www.visto.com/info</A>, your free web-based = communications center.</FONT>
<BR><FONT SIZE=3D2>Visto.com. Life on the Dot.</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Michael Chan</FONT>
<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, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P>
<BR>
<BR>
<P><FONT =
SIZE=3D2>_______________________________________________________________= ____________</FONT>
<BR><FONT SIZE=3D2>Visit <A HREF=3D"http://www.visto.com/info" =
TARGET=3D"_blank">http://www.visto.com/info</A>, your free web-based = communications center.</FONT>
<BR><FONT SIZE=3D2>Visto.com. Life on the Dot.</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Michael Chan</FONT>
<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, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
 |
 |