Message-Id: <10599.115458@fatcity.com> From: "Koivu, Lisa" Date: Thu, 24 Aug 2000 08:26:34 -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_01C00DC6.8AA382D2 Content-Type: text/plain; charset="iso-8859-1" Michael, how did you determine that your process is consuming 300M? -----Original Message----- From: Michael Chan [mailto:micchan@visto.com] Sent: Thursday, August 24, 2000 8:56 AM To: Multiple recipients of list ORACLE-L Subject: Memory usage for Oracle User Process 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). ------_=_NextPart_001_01C00DC6.8AA382D2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Memory usage for Oracle User Process

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

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


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 =