Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Memory usage for Oracle User Process
Lyall,
By using unix command top, there's a column showing the memory usage of = each process.
Cheers,
Michael
-----Original Message-----
From: Lyall Barbour lbarbour_at_stanford.edu
Sent: Thu, 24 Aug 2000 07:25:56 -0800
To: ORACLE-L_at_fatcity.com
Subject: Re: Memory usage for Oracle User Process
I think the PGA has a lot to do with single user memory consumption. I=20
don't remember what it stands for off the top of my head. But, I'm prett=
y=20
sure sort_area_size in the init.ora file has a lot to do with it. I'm al=
so=20
sure there are others, but sort_area_size is a major contributor.
HTH
Lyall Barbour
At 04:56 AM 8/24/00 -0800, you wrote:
>Hi,
>
>I found that some of the Oracle user process consumes memory as high as=20
>300M. (For a single process only!)
>
>Is there any tuning that I can do to control the memory usage on each us=
er=20
>process ?
>
>Database is version 8.1.6 on Solaris 2.6
>
>TIA,
>Michael
>
>
>________________________________________________________________________=
___
>Visit http://www.visto.com/info, your free web-based communications cent=
er.
>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).
--=20
Author: Lyall Barbour
INET: lbarbour_at_stanford.edu
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).
_________________________________________________________________________=__