RE: Memory usage for Oracle User Process

Message-Id: <10600.115549@fatcity.com> From: "Koivu, Lisa" Date: Fri, 25 Aug 2000 08:57:23 -0400 Subject: 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@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@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 ___________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot. -- Author: Michael Chan INET: micchan@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@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@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@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-printable RE: Memory usage for Oracle User Process

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@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@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

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

--
Author: Michael Chan
INET: micchan@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@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@visto.com