Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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)Received on Fri Oct 17 1997 - 00:00:00 CDT