Re: Size of oracle background processes

Its not the size of the SGA itself..I know the SGA is shared by all the Oracle background processes. The problem is that when I do a "top" on the solaris box each of the background SQL processes have a resident size of approximately the same size of the SGA..This will create too much swapping on the box Why should the size of these background processes be so huge. What is the connection between the resident size of the background processes and the SGA, Shouldn't they be independent of each other.

-anil

In article <7ss63n$q07$1_at_birch.prod.itd.earthlink.net>,   "Winnie Liu" <winnie_liu_at_infonet.com> wrote:
> I'm sorry if I got your message wrong. But what is the problem for the
700MB
> SGA database to have a combined shared memory usage size of
approximately
> 700MB (which will be shared by all the background oracle processes).
If your
> box is running too slow. Maybe there is too much swapping going on.
Increase
> the swap space or simply decrease the SGA size.
>
> Winnie Liu
> DBA
> Infonet Services Corporation
> mailto:winnie_liu_at_infonet.com
>
> Anil Kamath wrote in message <7srili$vks$1_at_nnrp1.deja.com>...
> >
> >
> >My SGA for Oracle 8.0.5 is configured to utilize 700 MB of memory.
> >What I see is that my background processes (dbw,reco,chpt...etc..)
> >show a resident memory size of approximately 700MB. Whats wrong with
> >this picture. This make my Solaris 2.6 box slow. Is this normal.
> >If so,,then what is the solution..
> >
> >-anil
> >
> >
> >--
> >Anil Kamath
> >SmartOnline Inc. (www.smartonline.com)
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

--
Anil Kamath
SmartOnline Inc. (www.smartonline.com)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 29 1999 - 12:35:18 CDT