Re: Server Process Memory Usage

In article <343d0a44.146492975_at_news.bctel.net>, matts_at_xxxnifcosynergy.com (Matt Southcott) writes:
> Could someone please tell me the usual amount of memory used
>per connection to an Oracle database running on a SUN box. At this
>time each connection is reserving 30m and using 44m just for a
>connection. I think that this is a little steep. Is there anyway to
>reduce the usage I can't seem to find any documentation on this
>anywhere here.
>
>Matt
>
>matts_at_direct.ca

I also wondered about this and found that the amount of memory per connection is related to the SGA size. Just do a "show sga" from "sqldba" to verify this...

Chris

-- 
Chris Connor(cconnor_at_rsa.hisd.harris.com)