Message-Id: <10599.115480@fatcity.com> From: "Eric Lansu" Date: Thu, 24 Aug 2000 17:15:20 +0200 Subject: Re: Memory usage for Oracle User Process 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@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@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@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 RE: Memory usage for Oracle User Process
I bet your SGA is about = 280M?
The memory-statistics on most = machines add the=20 SGA-size to the actual user-size. So to get this substract.
 
I've got 60 500Mb user-processes on a = 2Gb=20 machine, without swapping.... It's magic.....
 
Eric Lansu
----- Original Message -----
From:=20 Koivu, = Lisa
To: Multiple recipients of list ORACLE-L =
Sent: Thursday, 24 August 2000=20 15:25
Subject: RE: Memory usage for = Oracle User=20 Process

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

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


Hi,

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

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

Database is version 8.1.6 on Solaris 2.6

TIA,
Michael =


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

--
Author: Michael = Chan=20
  INET: micchan@visto.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San = Diego,=20 California        -- Public = Internet access=20 / Mailing Lists
----------------------------------------------------------------= ----=20
To REMOVE yourself from this mailing list, send an = E-Mail=20 message
to: ListGuru@fatcity.com (note EXACT = spelling=20 of 'ListGuru') and in
the message BODY, = include a line=20 containing: UNSUB ORACLE-L
(or the name of = mailing=20 list you want to be removed from).  You may
also=20