RE: Memory usage for Oracle User Process

Also, Solaris includes shared memory in the memory usage statistic.

The main init.ora parameters to affect PGA are sort_area_size and hash_area_size.

Kevin

> -----Original Message-----
> From: Lyall Barbour [mailto:lbarbour_at_stanford.edu]
> Sent: Thursday, August 24, 2000 11:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Memory usage for Oracle User Process
>
>
> I think the PGA has a lot to do with single user memory
> consumption. I
> don't remember what it stands for off the top of my head.
> But, I'm pretty
> sure sort_area_size in the init.ora file has a lot to do with
> it. I'm also
> 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
> >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_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).
>
> --
> 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).
Received on Thu Aug 24 2000 - 11:21:16 CDT