Re: SGA sizes

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 23 Sep 2001 16:21:52 +0200
Message-ID: <tqrs9bjqrrcf3c@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:21:52 CDT