Re: Size of oracle background processes

Hi Anil,
Could you verify the value of the parameter pre_page_sga. It looks like it it true, which means each process will map the entire sga in it's working set.

Hth,

--
Sybrand Bakker, Oracle DBA
Anil Kamath <akk_16_at_yahoo.com> wrote in message news:7stikl$d42$1_at_nnrp1.deja.com...
>
>
> 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 - 17:19:41 CDT