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).
Received on Thu Aug 24 2000 - 09:19:56 CDT
