Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SGA sizes

Re: SGA sizes

From: Thierry <thierry.constant2_at_wanadoo.fr>
Date: Sun, 23 Sep 2001 14:39:07 GMT
Message-ID: <fumr7.8829$Gi4.9731169@nnrp1.proxad.net>


Thanks for the answer ...

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de news: tqrs9bjqrrcf3c_at_news.demon.nl...
>
> "Thierry" <thierry.constant2_at_wanadoo.fr> wrote in message
> news:dWlr7.8816$nz4.9495658_at_nnrp1.proxad.net...
> > Hi,
> >
> > When Oracle start, it shows something like:
> >
> > Total SGA
> > Fixed Size
> > Variable Size
> > Database Buffers
> > Redo Buffers
> >
> > I understand Database Buffers and Redo Buffers
> > but what is Fixed Size and Variable Size ????
> >
> > Thanks
> >
> >
> >
>
> Variable size is the shared pool.
> Fixed size is administrative overhead which is independent of the size of
> the SGA.
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>
Received on Sun Sep 23 2001 - 09:39:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US